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

61 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
shadoofs155423(None) 
shadoof1446131shadoof_
shadows1437192shad_ows
shadufs1433672shad_ufs
bradoons1136763bradoons
chadors1338753chad_ors
haboobs1495463_haboobs
hadrons113314303_hadrons
handoffs1844733_handoffs
hoofs115721043_h__oofs
leadoffs1542303leadoffs
saloons74415323s_aloons
saloops93510133s_aloops
seaboots1047093seaboots
seadogs958643sead_ogs
seafoods1245673seafoods
sendoffs1543493sendoffs
shackoes17367853shackoes
shackos16429023shacko_s
shadblows1842473shadblows
shaddock1943273shaddock
shaddocks2043083shaddocks
shaders115915553shad_ers
shades105924533shad__es
shadings13327433shadings
shadow1337253shad_o_w
shadowed1644483shadowed
shadower1544873shadower
shadowers1644303shadowers
shadowy1744723shad_owy
shads95124483shad___s
shaduf1337063shad_uf_
shahdoms1743773shahdoms
shakoes144510023sha_koes
shakos134912193sha_ko_s
shalloons1245223shalloons
shallops13288323shallops
shallots11319503shallots
shallows14388863shallows
shaloms1288983sha_loms
shammos14307203shammo_s
shamois123210423sha_mois
shamos114216983sha_mo_s
shamoys15367283sha_moys
shampoos1544603shampoos
sharifs13279903sha_rifs
sheroots1137863sheroots
shnooks1485583sh_nooks
shooks134515633sh__ooks
shools94919013sh__ools
shoos84226363sh__oo_s
shoots94619363sh__oots
showoffs2042453showoffs
shroffs1634363sh_roffs
shutoffs1752073shutoffs
skidoos1234463skidoo_s
spadones1137253spadones
spoofs114011813s__poofs
standoffs1642673standoffs
sunroofs1144763sunroofs
whoofs15457243wh__oofs

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.423422437.4
2DLD Change Limit146162616.67021913.3
3Display Results61610.0163812.5
 (SQL Overall)178691617.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.