Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “licensing” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

75 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
licensing124475(None) 
licencing1443851licencing
censing104215262__censing
incensing1297662incensing
lensing84015102l__ensing
lichening1545672lichen_ing
likening13246892liken_ing
livening12248152liven_ing
relicensing1443312relicensing
accenting1487833accenting
accessing1445833accessing
aliening91510893ali_en_ing
alimenting1344503alimenting
ascending1336283ascending
ceasing104118263__ceasing
cessing103814813__cessing
deceasing1338403deceasing
defensing14217003defensing
diseasing11310833diseasing
dispensing1448233dispensing
dizening19177153dizen_ing
excessing1945713excessing
expensing1946003expensing
finessing1345123finessing
flensing1246973_flensing
incenting12912063incenting
lacewing1435843lace_wing
ladening1078823laden_ing
laicising1245623laic_ising
lamenting1237703lamenting
latening9711493laten_ing
leasing83920163l__easing
lending94118533l__ending
liaising937913li_aising
libeling1139873libe_ling
libelling1236883libelling
license9148423licens__e
licensed11145723licens_ed
licensee10166303licens_ee
licensees1184473licensees
licenser10155883licens_er
licensers11114583licensers
licenses10118923licens_es
licensor10113723licens_or
licensors11104023licensors
licensure1143043licensure
lichenin1345053lichen_in_
lichenins1444843lichen_ins
lichting14268513lic_hting
licking144118283lic__king
limning103710323li_mn_ing
lining74526803li__n_ing
linking123818253li__nking
linsang835863li__nsang
linting83820983li__nting
lionising1046463lionising
lippening14234943lippen_ing
listening10128953listen_ing
livering122012383live_ring
mensing103915103__mensing
recessing12611013recessing
richening1546223richen_ing
rinsing82516113ri__nsing
ripening1138573ripen_ing
scending122610583_scending
scenting113212813_scenting
sensing84116953__sensing
sickening1635993sicken_ing
silencing1245053silencing
slickening1743903slicken_ing
sublicensing1751563sublicensing
tensing84616653__tensing
unceasing1239653unceasing
widening13237833widen_ing
wizening21255473wizen_ing

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.436409841.7
2DLD Change Limit148641757.11020905.9
3Display Results75750.0461630.4
 (SQL Overall)178691757.59223536.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.