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 “deuced” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

68 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
deuced10411212(None) 
deduced1266681deduced
deiced104214481deiced
deuce84517491deuce_
deuces94015511deuces
educed10418851educed
adduced1274352adduced
danced105315252danced
daubed104611782daubed
dauted84114932dauted
deaned84620452deaned
deaved114916552deaved
debuted11379332debuted
decked145217622decked
deduce1079252deduce_
deduces1168792deduces
deducted1356242deducted
deed65340902de__ed
deeded94615542deeded
deemed104713062deemed
defaced142910972defaced
defied115016382defied
defused125211092defused
defuzed21447042defuzed
deice84320032deice_
deicer94114412deicer
deices94119372deices
deked115718532de_ked
deled75326542de_led
deluded10158762deluded
deluged10167412deluged
delved114112752delved
demoed103713442demoed
denied84318632denied
denned84215632denned
dented84120512dented
denuded10167662denuded
deputed114610172deputed
descend11248152descend
deucedly1543552deucedly
dewed105020302de_wed
diced95824682d_iced
disced104914652disced
douce85518422douce_
douched144012112douched
doused84821162doused
duce76933502d_uce_
duces86327472d_uces
ducked144718012d_ucked
ducted104012122d_ucted
duded84417132d_uded
dueled84813662dueled
dueted84113592dueted
duked115218462d_uked
duped95118322d_uped
dured75025402d_ured
educe84313452educe_
educes94011952educes
fenced124412712fenced
feuded114010002feuded
feued94715662feu_ed
peaced115818912peaced
reduced11610322reduced
reused75419562reused
sauced93913302sauced
seduced1186752seduced
truced95312052truced
yeuked14456232yeuked

Search took 5 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 Filter178691825510.343520965.0
2DLD Change Limit82551684.28319274.1
3Display Results68680.0135230.8
 (SQL Overall)178691684.63938519.3
 
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.