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

53 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
chuddars1525345(None) 
cheddars15234371cheddars
chuddahs18222581chuddahs
chuddar14263961chuddar_
chudders15235551chudders
chadars1338272ch_adars
cheddar14254732cheddar_
cheddary18293332cheddary
chuddah17263252chudda_h
chudder14245942chudder_
chukars1634272chu_kars
chukkars1642002chukkars
khaddars1741992khaddars
shudders13316642shudders
budders113812103_budders
cedars93312833c__edars
chadar1239343ch_adar_
chadors1338723ch_adors
chars105936633ch___ars
cheders134512393ch_eders
chiders135312943ch_iders
chimars144010573ch_imars
chowders17387533chowders
chufas14397673chu_fa_s
chuggers1554853chuggers
chukar1534633chu_kar_
chukkar1542053chukkar_
chukkas1532783chukka_s
chukkers1633473chukkers
chunters133910893chunters
chuppahs2042073chuppahs
chuppas1644123chuppa_s
churners13316883churners
churrs115111513chu__rrs
codders114114443c_odders
cougars1038423cou_gars
cudbears1343473c_udbears
cuddies113313263c_uddies
cuddlers12388383c_uddlers
cuddles114014093c_uddles
huddlers13337633_huddlers
huddles123712573_huddles
hussars10326973_hussars
judders16347793_judders
khaddar1642113khaddar_
mudders113211103_mudders
rudders93210643_rudders
shedders13267433shedders
shudder12297323shudder_
shuddery16263413shuddery
spudders12255633spudders
thunders1236943thunders
udders83911293__udders

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 Filter1786911461620.1731032896.0
2DLD Change Limit146162538.64016916.9
3Display Results53530.0163312.5
 (SQL Overall)178691538.82920239.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.