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

110 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
idealist931065(None) 
idealise938051idealise
idealism1147011idealism
idealists1047221idealists
delist74625052_de_list
dialist8517762_dialist
dualist8614052_dualist
idealess935652idealess
idealised1145672idealised
idealises1047782idealises
idealisms1246442idealisms
idealistic1344702idealistic
ideality1247152ideality
idealize1847872idealize
ideals75012502ideal_s_
idylist1146652id_ylist
idyllist1243962idyllist
medalist11414212medalist
realist73225382_realist
alist56136783___alist
annalist8413753annalist
arbalist10313333arbalist
cabalist12314503cabalist
cellist9314423_cellist
deadest93014883_deadest
deadliest1138183_deadliest
deadlift1345633_deadlift
deafest112911513_deafest
deafish1438533_deafish
dealfish1545503_dealfish
dealing94323233_dealing
deals65435343_deal_s_
dealt65234283_deal__t
dearest83618673_dearest
deist64633593_de__ist
delict94320333_de_lict
delis64928543_de_lis_
delish105215613_de_lish
delists84414173_de_lists
dentist8316743_dentist
desist74818813_de_sist
dialists9411413_dialists
diallist949553diallist
diarist8517113_diarist
digamist1248213digamist
dualism1049163_dualism
dualists958243_dualists
duelist8511413_duelist
duellist986333duellist
enlist6417043__enlist
fatalist11314973fatalist
federalist1446443federalist
fideist1139753fide__ist
fidelista1343203fide_lista
finalist113014733finalist
fiscalist1446573fiscalist
ideal65716393ideal___
idealising1245703idealising
idealized2046653idealized
idealizer1945473idealizer
idealizes1947383idealizes
idealless1042953idealless
ideally1137793ideal_ly
idealogy1342943idealogy
ideas65919013idea__s_
ideates8313733ideates_
ideating10311703ideating
ideation9310493ideation
ideative1238573ideative
ideologist1248533ideologist
idlest74014863id__lest
idolise839293id_olise
idolism1037273id_olism
idylists1244123id_ylists
idyllists1342443idyllists
imagist1077333i_magist
kabalist14410083kabalist
legalist9512393legalist
libelist10310823libe_list
liberalist1249063liberalist
literalist10411533literalist
localist101613963localist
loyalist111511133loyalist
mealiest102215973_mealiest
medalists1249373medalists
medallist1246643medallist
metalist10519353metalist
midlist10312513mid__list
modelist11310503mode_list
moralist10316663moralist
muralist10312983muralist
niellist848353niellist
odalisk1265373od_alisk
oralist7619633_oralist
realest73322433_realest
realise73021813_realise
realism93115923_realism
realists83014843_realists
reenlist8410363reenlist
relist64628413_re_list
ritualist948643ritualist
royalist111311983royalist
ruralist8311703ruralist
sealift10312793_sealift
sodalist9311883sodalist
totalist8315583totalist
vealiest112513203_vealiest
visualist1246773visualist
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.1701051123.5
2DLD Change Limit1461621106.94021060.8
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.15624970.8
 
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.