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

91 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
idylist114665(None) 
idylists1244121idylists
idyllist1243961idyllist
delist74625052_delist
dialist8517762dialist
idealist9310652idealist
idlest74014862id_lest
idolise839292idolise
idolism1037272idolism
idyllists1342442idyllists
idylls10425252idylls_
idyls9498802idyl_s_
midlist10312512mid_list
stylist102110282stylist
alist56136783__alist
biblist11310833biblist
bicyclist1853443bicyclist
cellist9314423cellist
chymist17268173chymist
cyclist1438853cyclist
daylit10512493dayli_t
deist64633593_d_eist
delict94320333_delict
delis64928543_delis_
delish105215613_delish
delists84414173_delists
desist74818813_desist
dialists9411413dialists
diallist949553diallist
diarist8517113diarist
dualist8614053dualist
duelist8511413duelist
dynast1088223_dynast
enlist6417043_enlist
fideist1139753fid_eist
fidelista1343203fidelista
finalist113014733finalist
holist94723213_holist
idealise938053idealise
idealism1147013idealism
idealists1047223idealists
idiot6718863id__iot
idles66720123id_les_
idling8912883id_ling
idolised1045673idolised
idoliser945043idoliser
idolises938763idolises
idolisms1146353idolisms
idolize1737783idolize
idols65514133idol_s_
idyl85912303idyl___
idyll9436713idyl__l
idyllic1342973idyllic
illest63615723i_llest
imagist1077333imagist
inflict1248623inflict
insist6314513i_nsist
intwist1038043intwist
ironist7314843ironist
ivylike1734283ivylike
libelist10310823libelist
list47055343___list
loyalist111511133loyalist
lyrist9312293_lyrist
medalist11414213medalist
midlists1137523mid_lists
modelist11310503modelist
niellist848353niellist
nihilist1147163nihilist
oculist9310883oculist
odalisk1265373odalisk
odist6421913od__ist
odyles10348563odyles_
odyls9428653odyl_s_
oralist7619633oralist
playlist1347573playlist
pollist9816603pollist
realist73225383realist
relist64628413_relist
royalist111311983royalist
simplist12249683simplist
skylit1338283skyli_t
sodalist9311883sodalist
stylise10208953stylise
stylish13197443stylish
stylists11207023stylists
sylis84316023_sylis_
titlist7312923titlist
typist1139823_typist
violist10312143violist
vitalist11313393vitalist

Search took 9 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 Filter1786911340270.406440125.6
2DLD Change Limit134027917.83017117.1
3Display Results91910.0303033.3
 (SQL Overall)178691918.26621617.6
 
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.