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

120 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
finalist11301473(None) 
finalis103313661finalis_
finalise113112571finalise
finalism133010361finalism
finalists123010161finalists
annalist8413752annalist
dialist8517762di_alist
fatalist11314972fatalist
finales104016012finales_
finalised13338012finalised
finalises122911522finalises
finalisms14318832finalisms
finality1448342finality
finalize202711022finalize
finals94316162final_s_
fiscalist1446572fiscalist
vitalist11313392vitalist
alist56136783___alist
analyst10189323_analyst
animalist11511643animalist
annalists949063annalists
arbalist10313333arbalist
atonalist9411833atonalist
bialis83617163bi_alis_
biblist11310833bi_blist
bigamist1347063bigamist
binarism1248353binarism
cabalist12314503cabalist
canalise10816213canalise
dialists9411413di_alists
diallist949553diallist
diarist8517113di_arist
digamist1248213digamist
dualist8614053_dualist
dynamist1445343dynamist
enlist6417043_en_list
fabulist1347673fabulist
fantasist1288003fantasist
fatalism13310493fatalism
fatalists12310023fatalists
feudalist1356303feudalist
ficklest17267903ficklest
fideist1139753fi_deist
fidelista1343203fidelista
finagles12237553finagles_
finagling1434703finagling
final83922033final___
finale94116763final__e
finalising1446673finalising
finalized22279243finalized
finalizer21307923finalizer
finalizes212810743finalizes
finally13310103final_ly
finest94321733fin__est
finfish16268193fin_fish
finials103210153finial_s_
finis86824263fin__is_
finish124613423fin__ish
finless102810783fin_less
finlike14279063fin_like
finniest113011403finniest
firelit10310863fireli_t
fiscalists1544673fiscalists
focalise131210373focalise
formalist141910643formalist
frontlist1246123frontlist
handlist12311333handlist
idealist9310653idealist
idylist1146653_idylist
imagist1077333_imagist
inanest72115363_inanest
inflict1248623_inflict
insist6314513_in_sist
intwist1038043_intwist
jingliest1735973jingliest
jingoist16126263jingoist
kabalist14410083kabalist
kindliest1436113kindliest
kingliest1436523kingliest
legalist9512393legalist
libelist10310823libelist
linguist948573linguist
localist101613963localist
loyalist111511133loyalist
medalist11414213medalist
mentalist11515553mentalist
metalist10519353metalist
midlist10312513mi_dlist
minimalist14116493minimalist
moralist10316663moralist
muralist10312983muralist
niellist848353niellist
nihilist1147163nihilist
nominalist1248163nominalist
onanist7314633_onanist
oralist7619633_oralist
panelist10414513panelist
penalise101013763penalise
pianist9615103pi_anist
realist73225383_realist
ritualist948643ritualist
royalist111311983royalist
ruralist8311703ruralist
signalise1046393signalise
simplist12249683simplist
sinapism1245573sinapism
sitarist8315283sitarist
sodalist9311883sodalist
tingliest1047683tingliest
tinkliest1336133tinkliest
titlist7312923ti_tlist
totalist8315583totalist
tribalist1149953tribalist
vinals94716483vinal_s_
violist10312143vi_olist
visualist1246773visualist
vitalise11310743vitalise
vitalism1339683vitalism
vitalists1239223vitalists
vocalist131512123vocalist

Search took 7 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 Limit1461621206.50022486.5
3Display Results1201200.0462608.7
 (SQL Overall)1786911206.96925640.8
 
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.