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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
annalist841375(None) 
annalists949061annalists
analyst10189322a_nalyst
animalist11511642animalist
annalistic1276442annalistic
annals66415922annal_s_
arbalist10313332arbalist
atonalist9411832atonalist
finalist113014732finalist
aerialist9914263aerialist
agnails837003agnails_
alist56136783___alist
alkalis11148793alkalis_
alkalise12178043alkalise
anality10313633a_nality
analogist10410233a_nalogist
analyse10208893a_nalyse
analysts11167443a_nalysts
anapest9311553a_napest
animalism1358613animalism
animalists1258243animalists
animatist11411003animatist
animist93815173a_nimist
annal56520763annal___
annas55824883anna__s_
annates72415423annates_
annealing1047453annealing
anneals7449943anneal_s_
annelid838733anneli_d
annelids946233annelids
annualize1845613annualize
annuals7388193annual_s_
annulet7311593annul_et
annulets845813annulets
annuli6459053annuli__
annulose844473annulose
annuls64711733annul_s_
annulus7426613annulus_
apiarist10412053apiarist
aquarist171010083aquarist
arbalest1039523arbalest
arbalists1148483arbalists
argalis84214193argalis_
atavist10311093a_tavist
atonalism1148463atonalism
atonalists1048493atonalists
auntliest936323auntliest
aviarist11410113aviarist
cabalist12314503cabalist
cabbalist1547643cabbalist
canalise10816213canalise
cannabis1266033cannabis_
cannolis1037863cannolis_
dialist8517763_dialist
dualist8614053_dualist
dynamist1445343dynamist
enlist6417043_en_list
fantasist1288003fantasist
fatalist11314973fatalist
finalis103313663finalis_
finalise113112573finalise
finalism133010363finalism
finalists123010163finalists
handlist12311333handlist
idealist9310653idealist
kabalist14410083kabalist
kabbalist1744613kabbalist
legalist9512393legalist
localist101613963localist
loyalist111511133loyalist
mannerist1149103mannerist
medalist11414213medalist
mentalist11515553mentalist
metalist10519353metalist
moralist10316663moralist
muralist10312983muralist
nasalise848863nasalise
nasalism1048203nasalism
onanist7314633_onanist
oralist7619633_oralist
panelist10414503panelist
penalise101013763penalise
racialist11411203racialist
realist73225383_realist
royalist111311983royalist
ruralist8311703ruralist
sodalist9311883sodalist
tantalise91210823tantalise
totalist8315583totalist
unnails738223unnails_
vandalise1347673vandalise
vandalish1645993vandalish
vandalism1546873vandalism
vitalist11313393vitalist
vocalist131512123vocalist

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.420425454.8
2DLD Change Limit146162956.73621698.6
3Display Results95950.0303166.7
 (SQL Overall)178691957.18624866.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.