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

106 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
sveltest113587(None) 
saltest71916512s_altest
snellest839492snellest
svelte9319752svelte__
sveltely1442842sveltely
svelter10359672svelte_r
sweetest1137172sweetest
swellest1137662swellest
adeptest1145453adeptest
alertest8310173alertest
deftest112611713_deftest
detest74122843_de_test
eeliest73516473_eeliest
eldest72912683__eldest
evenest10312103eve_nest
evilest10310473evil_est
evillest1146353evillest
featest102715113_featest
fellest10313753_fellest
fleetest1136723fleetest
greatest939863greatest
leftest10269463_leftest
liveliest1247093liveliest
loveliest1246973loveliest
neatest72516003_neatest
peltast9310513_peltast
pertest9317043_pertest
pretest9517633pre_test
retest64028453_re_test
saltiest83117713s_altiest
scaliest101714393scaliest
scantest101710183scantest
searest73322023s_earest
sedatest9249393sedatest
seediest92714053seediest
seemliest1145623seemliest
seepiest102412623seepiest
select82621173s_el_ect
selles64426983s_elles_
selves94119613s_elves_
septet8921133s_epte_t
septets998953s_eptets
serest64831613s_e_rest
sestet6826203s_este_t
sestets7911473s_estets
severest11310323severest
sexiest142112223s_exiest
sextet13916873s_exte_t
sextets1497143s_extets
shaliest111415053shaliest
sheerest11310083sheerest
shelliest1238023shelliest
sheltas10279673sheltas_
shelter103214963shelte_r
shelters113412813shelters
shelties111111383shelties_
shelves134112093shelves_
shelviest1535003shelviest
shortest11310783shortest
silentest948103silentest
silliest84017103silliest
siltiest83515613s_iltiest
skelter113610003skelte_r
skelters12349373skelters
sleekest1236153sleekest
sleetiest938553sleetiest
sliest66621953s__liest
slyest93811363s__lyest
smallest1039403smallest
smartest10310183smartest
smelliest1136603smelliest
smelted10399093smelte_d
smelter93311913smelte_r
smelters103310513smelters
smeltery13274963smeltery
smelts85412773smelt_s_
softest10310603s_oftest
spelter94113703spelte_r
spelters103912243spelters
spelts84614643spelt_s_
speltzes1944003speltzes_
stalest73720173stal_est
steeliest939643steeliest
steepest1038123steepest
steles63725663stel_es_
sternest8314433sternest
stillest8311073stillest
stoutest837613stoutest
subtest9513963s_ubtest
subtlest10511363subtlest
surliest82416913surliest
svelteness1344423svelteness
sweatiest1238413sweatiest
swelter103711173swelte_r
swelters113110193swelters
sweltriest1343283sweltriest
swiftest1434353swiftest
vastest102911513_vastest
vealiest112513203_vealiest
velites103417303_velites_
velvet123613753_velve_t
velvets13326693_velvets
veriest103719133_veriest
vilest9416843_vil_est
voltes94915583_voltes_
wettest10239363_wettest

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621067.73618893.7
3Display Results1061060.0462304.3
 (SQL Overall)1786911068.18821823.5
 
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.