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

37 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
idyllist124396(None) 
idylist1146651idy_list
idyllists1342441idyllists
diallist949552diallist
idealist9310652idealist
idylists1244122idy_lists
idyllic1342972idylli_c
idylls10425252idyll_s_
bicyclist1853443bicyclist
cellist9314423_cellist
cyclist1438853_cyclist
delist74625053_d_elist
dialist8517763_dialist
diallists1056003diallists
dollish11610093_dollish
dualist8614053_dualist
duelist8511413_duelist
duellist986333duellist
dullest8312633_dullest
dullish1148743_dullish
idealise938053idealise
idealism1147013idealism
idealists1047223idealists
idlest74014863id__lest
idolise839293id_olise
idolism1037273id_olism
idyll9436713idyll___
idyls9498803idy_l_s_
illest63615723i__llest
loyalist111511133loyalist
medallist1246643medallist
midlist10312513mid__list
niellist848353niellist
phallist1338993phallist
pollist9816603_pollist
royalist111311983royalist
stylist102110283sty_list

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 Limit146162376.17023689.1
3Display Results37370.0162312.5
 (SQL Overall)178691376.60927037.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.