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 “lessening” 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.

88 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
lessening104533(None) 
lessoning1044771lessoning
leadening1176732leadening
leavening1365972leavening
lesioning1046442lesioning
listening10128952listening
loosening1044932loosening
assenting1038163_assenting
basseting1236153basseting
beseeming1435143beseeming
besieging1344763besieging
blessing1137593bless__ing
cessing103814813cess__ing
cosseting1239543cosseting
deadening1277583deadening
deafening1476273deafening
deepening1335613deepening
descending1546113descending
desexing1736293de_sexing
designing1236623designing
destining11311433destining
dissenting121310293dissenting
essaying1235033_essaying
evening11310223_e_vening
fastening13268603fastening
fessing113812863fess__ing
festering132413173festering
flehmening1942243flehmening
freshening1744773freshening
glistening1294283glistening
gusseting1173963gusseting
hastening13259483hastening
jessing153710623jess__ing
keening123713153ke__ening
ladening1078823l_adening
lassoing946383lass_oing
latening9711493l_atening
leaning83721203le__aning
learning978553le_arning
leashing123310313leas_hing
leasing83920163leas__ing
leavenings1472583leavenings
lechering1538443lechering
leering83417643le__ering
leistering1147983leistering
lensing84015103lens__ing
lessen64212433lesse__n_
lessened935103lessen_ed
lessens7409383lesse__ns
lettering102112073lettering
leveeing12265963le_veeing
leveling122910433le_veling
levering122212503le_vering
lichening1545673lichening
likening13246893l_ikening
lippening14234943lippening
livening12248153l_ivening
loudening1144743loudening
lustering102711203lustering
messaging1345343messaging
messing103916393mess__ing
missending1446493missending
neatening1038353neatening
peening103318303pe__ening
pestering122315663pestering
reasoning10310203reasoning
reddening1237433reddening
reopening1248823reopening
reseeding112410493reseeding
reseeing92412623re_seeing
reseeking14208493reseeking
resending112313363re_sending
resenting102619293re_senting
resewing122712263re_sewing
reshining13310743reshining
resigning1139463resigning
resining92919553re_sining
russeting1065323russeting
seasoning1037413seasoning
sleekening1543073sleekening
tasseling1035853tasseling
teaseling1036913teaseling
weakening1734843weakening
weaseling1335613weaseling
weening114113973we__ening
westering132112643westering
worsening1345553worsening
yessing113210063yess__ing

Search took 9 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.466383457.1
2DLD Change Limit148641887.55019687.5
3Display Results88880.0302933.3
 (SQL Overall)178691888.04622208.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.