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 “knesset” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
knesset1131041(None) 
knessets1243171knessets
cresset93319942cresset
keyset13411522k_eyset
nesses64718322_nesses
anenst63514983anens_t
asset55932263__asset
basset85225383_basset
beset76739133_be_set
blessed10319493blessed
blesser9329293blesser
blesses93812393blesses
boneset9316433bone_set
cessed94615613_cessed
cesses84221363_cesses
chesses124112633chesses
cosset84125863_cosset
cresses94219813cresses
cressets10309103cressets
densest83112473densest
dessert82916453_dessert
dressed93511873dressed
dresser83611953dresser
dresses83716173dresses
esses56422973__esses
fesse86116333_fesse_
fessed104515063_fessed
fesses94820253_fesses
finesse10187643finesse_
finessed12136793finessed
finesses111912343finesses
freshet133416643freshet
gneisses933673gneisses
guessed9176603guessed
guesser8166543guesser
guesses8169373guesses
gusset7316433_gusset
inset54430863in__set
jesse126012833_jesse_
jessed144112303_jessed
jesses135215953_jesses
keenest11410963keenest
keester11319913keester
keet85347333k_e__et
kersey1336783k_ersey
keysets1434343k_eysets
kiester11329973kiester
kineses113111253kine_ses
kismet123414623k_ismet
kissed114412853k_issed
kisser104212453k_isser
kisses104217333k_isses
kneaded13146473kneaded
kneader1275893kneader
knee85323603kne__e_
kneed104612053kne__ed
kneel95012033kne__el
kneeled12328063kneeled
kneeler11277573kneeler
knees95114873kne__es
kneesies1245543kneesies
knelled12338983knelled
knelt94617683kne__lt
knishes1438263knishes
kvasses14365503kvasses
lessee64116363_lessee
lessen64212433_lessen
lesser63514853_lesser
loesses7310033loesses
messed95018183_messed
messes84924343_messes
misset85028153_misset
neist54628443_neis_t
ness45526563_ness__
nest45548733_ne_s_t
nested74720063_nested
nester64124183_nester
newest9314213_newest
onset54730173on__set
overset102821473overset
oyesses1037333oyesses
posset84923253_posset
preset84430983pre_set
pressed103317313pressed
presser93717623presser
presses93523153presses
reset55051863_re_set
russet6319433_russet
sestet6826203_sestet
tasset65925313_tasset
tensest72713313tensest
tressed83714263tressed
tressel73010893tressel
tresses73719543tresses
underset91417133underset
unease63816643unease_
uneases73316263uneases
unset54532433un__set
verset94327323_verset
vessel937953_vessel
yessed104511163_yessed
yesses93615813_yesses

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271027.04619021.7
3Display Results1021020.0333090.9
 (SQL Overall)1786911027.23524698.1
 
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.