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

101 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
finalists12301016(None) 
finalises122911521finalises
finalisms14318831finalisms
finalist113014731finalist_
annalists949062annalists
dialists9411412di_alists
fatalists12310022fatalists
finalis103313662finali__s
finalise113112572finalis_e
finalised13338012finalised
finalism133010362finalis_m
finality1448342finali_ty
finalizes212810742finalizes
fiscalists1544672fiscalists
vitalists1239222vitalists
analysts11167443_analysts
animalists1258243animalists
annalist8413753annalist_
arbalists1148483arbalists
atonalists1048493atonalists
biblists1236873bi_blists
bigamists1444523bigamists
binarisms1346413binarisms
cabalists1339153cabalists
canalises11515493canalises
dialist8517763di_alist_
diallists1056003diallists
diarists9410363di_arists
digamists1345003digamists
dualists958243_dualists
dynamists1544093dynamists
enlists749393_en_lists
fabulists1444723fabulists
fantasists1385503fantasists
fatalisms1439113fatalisms
fatalist11314973fatalist_
feudalists1454573feudalists
fideists1245543fi_deists
fidelista1343203fidelista
fidelistas1451873fidelistas
finales104016013final__es
finalising1446673finalising
finalities1349903finalities
finalize202711023finali_ze
finalized22279243finalized
finalizer21307923finalizer
finalizers22264903finalizers
finals94316163final___s
finises10312903fin__ises
finless102810783fin_les_s
fiscalist1446573fiscalist_
focalises14139953focalises
formalists15217623formalists
frontlists1344523frontlists
handlists1347133handlists
idealists1047223idealists
idylists1244123_idylists
imagists1175113_imagists
inflicts1345613_inflicts
insists739083_in_sists
intwists1145593_intwists
jingoists17113763jingoists
kabalists1546293kabalists
legalists1047943legalists
libelists1146953libelists
linguists1045743linguists
localists11149793localists
loyalists12137473loyalists
medalists1249373medalists
mentalists12410483mentalists
metalists11412663metalists
midlists1137523mi_dlists
minimalists15114603minimalists
moralists11311103moralists
muralists1148163muralists
niellists944793niellists
nihilists1244853nihilists
nominalists1355733nominalists
onanists838413_onanists
oralists8611803_oralists
panelists1148343panelists
penalises11912773penalises
pianists1049013pi_anists
realists83014843_realists
ritualists1046173ritualists
royalists12178113royalists
ruralists947643ruralists
signalises1145913signalises
simplists13266503simplists
sinapisms1344793sinapisms
sitarists949373sitarists
sodalists1038153sodalists
titlists837293ti_tlists
totalists9310753totalists
tribalists1286943tribalists
violists1137663vi_olists
visualists1344893visualists
vitalises12310093vitalises
vitalisms1448513vitalisms
vitalist11313393vitalist_
vocalists14108893vocalists

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411017.48319863.8
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.95222471.2
 
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.