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

104 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
tempests123444(None) 
tempest1139221tempest_
tempehs14325152tempe_hs
temperas12278232temperas
tempers113513012tempe_rs
tempested1444032tempested
templets12226142templets
tempts10439452temp__ts
anapests1046613anapests
armrests1055383armrests
bedposts1343873bedposts
behests1235953be_hests
bemists113410703bem_ists
bequests1944113bequests
cements112714223cem_ents
composts144210913composts
dampest12411043dampest_
deepest10310443deepest_
demasts1089223dem_asts
dements103016623dem_ents
detests83711743de_tests
devests114410473de_vests
egests74411253_e_gests
emeses86114963_em_eses
emesis84712623_em_esis
emmets10349153_emme_ts
empress1138163_empres_s
expects1866883_expects
experts1659063_experts
geests75912163ge__ests
hempiest1539023hempiest_
heppest14228143heppest_
imposts11269003_imposts
imprests1246313_imprests
jimpest18297553jimpest_
limpest113712313limpest_
limpets11329783limpe_ts
nemeses948663nem_eses
nemesis937373nem_esis
perpents122312043perpents
pests75933273___pests
reests64618893re__ests
remeets93712413rem_eets
remelts93511493rem_elts
renests74014213re_nests
repasts93611933re_pasts
repeats94316053re_peats
repents93717623re_pents
requests1735743requests
respects1247703respects
retests73813853re_tests
revests104413733re_vests
serpents102410373serpents
steepest1038123steepest_
stemless1036653stemles_s
tamest85721293tam_est_
tampers113516743tampe_rs
tappets113610013tappe_ts
teapots939053teap_ots
teepees939263teepe_es
teleosts846423teleosts
teleses7313123te_leses
telesis7310793te_lesis
telnets738373telne_ts
temped113912893tempe__d
tempeh13357463tempe__h
temper103914093tempe__r
tempera11329043tempe_ra
temperate1348513temperate
tempered13248223tempered
temperer12227723temperer
temperers13247023temperers
tempesting1544453tempesting
tempestuous1551353tempestuous
templars1255263templars
template1238433template
templates1348273templates
temples112610893temp_les
templet112712003templet_
tempos103812293temp__os
temps95417133temp___s
tempt95124843temp__t_
tempters12257293tempters
temptress1343133temptres_s
tempuras12295063tempuras
tenets65518953te_ne_ts
tennists8297793tennists
tensest72713313tensest_
tepees84215243te_pe_es
tercets93512443terce_ts
termless1036233termles_s
terpenes102111573terpenes
terrets72913583terre_ts
tersest71713993tersest_
tests56530193t___ests
tippets11339373tippe_ts
tmeses85712243t_m_eses
tmesis8529793t_m_esis
topmasts1244973topmasts
trapeses1039153trapeses
trapnests1144433trapnests
trumpets12315573trumpe_ts
typesets1343213t_ypesets
typists1236173t_ypists

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621046.73321708.3
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.20224811.3
 
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.