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

74 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
duellist98633(None) 
duelist8511411due_list
duellists1053751duellists
cellist9314422_cellist
delist74625052d_e_list
diallist949552diallist
dualist8614052du_alist
duelists966002due_lists
duelli767002duelli__
duelling103410732duelling
duellos845762duellos_
duettist945512duettist
dullest8312632du_llest
dullish1148742du_llish
niellist848352niellist
bulliest104314503bu_lliest
bullish12511193bu_llish
cellists1038563_cellists
cruellest1155583cruellest
cullis84115993cu_llis_
cultist91412713cu_ltist
deist64633593d_e__ist
delict94320333d_e_lict
delis64928543d_e_lis_
delish105215613d_e_lish
delists84414173d_e_lists
dellies83622213d_ellies
dells66630943d_ell_s_
dentist8316743d_entist
desist74818813d_e_sist
dialist8517763d_ialist
diallists1056003diallists
dollish11610093d_ollish
drollest937353drollest
dualism1049163du_alism
dualists958243du_alists
duelers83412053duelers_
dueling93614543due_ling
duelled9359753duell_ed
dueller8329833duell_er
duellers9268223duellers
duello756783duell__o
duels65619233due_l_s_
duettists1043043duettists
dulling93418273du_lling
dulls64523743du_ll_s_
duxelles1643963duxelles_
dwelling13368413dwelling
dwells10417713dwell_s_
enlist6417043__enlist
fellest10313753_fellest
fuelling123410153fuelling
fullest10313343fu_llest
hellish13310723_hellish
idealist9310653idealist
idyllist1243963idyllist
mueslis935493mueslis_
muralist10312983muralist
niellists944793niellists
phallist1338983phallist
pollist9816603_pollist
pugilist11136633pugilist
quelling18259793quelling
quells15359703quell_s_
querist16311133que_rist
realist73225383_realist
reenlist8410363reenlist
relist64628413_re_list
ruralist8311703ruralist
shelliest1238023shelliest
smelliest1136603smelliest
snellest839493snellest
swellest1137663swellest
trellis739873trellis_

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 Limit146162746.39022873.6
3Display Results74740.0332242.4
 (SQL Overall)178691746.84626101.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.