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

49 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
schmucks214276(None) 
schmuck2043041schmuck_
shmucks1833941s_hmucks
chucks174812932_ch_ucks
schlocks19245692schlocks
schticks19193952schticks
shmuck1734242s_hmuck_
shucks154010412s_h_ucks
amucks1466003__amucks
checks174912703_ch_ecks
chicks175317593_ch_icks
chipmucks2451133_chipmucks
chocks174815313_ch_ocks
chuck164814873_ch_uck_
chucky20418003_ch_ucky
chunks154210333_ch_unks
clucks144512073_c_lucks
crucks144412583_c_rucks
hucks144322173__h_ucks
mucks134622643___mucks
sawbucks1943413sawbucks
schlock18235873schlock_
schlocky22243383schlocky
schlubs1443193schlu_bs
schlumps1742743schlumps
schmears1584103schmears
schmeers1574833schmeers
schmoes14308543schm_oes
schmoos14347513schm_oos
schmos13379153schm__os
schnecke1942603schnecke
schnooks1754243schnooks
schriks16185743sch_riks
schtick18194523schtick_
schtiks16184743sch_tiks
schuits1235823sch_uits
schuls11299853sch_u_ls
schuss11186733sch_u_ss
sculks123610263sc__ulks
shacks154817563s_h_acks
sheuchs15234933s_heuchs
shlocks16317183s_hlocks
shocks154414583s_h_ocks
shticks16356963s_hticks
shuck144314533s_h_uck_
smacks144112323s__macks
smocks145710013s__mocks
sucks114523073s___ucks
upchucks2141703upch_ucks

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.406440125.6
2DLD Change Limit146162498.09318060.3
3Display Results49490.0163062.5
 (SQL Overall)178691498.51520985.4
 
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.