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

56 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
educe8431345(None) 
deduce1079251deduce
deuce84517491deuce
duce76933501_duce
educed10418851educed
educes94011951educes
educt85017101educt
reduce9713251reduce
seduce9610021seduce
abduce1197192abduce
adduce1076452adduce
bedunce1235682bedunce
dace76934922_dace
deduced1266682deduced
deduces1168792deduces
deduct10610792deduct
deice84320032deice
deuced104112122deuced
deuces94015512deuces
dice75841892_dice
douce85518422douce
duces86327472_duces
duci76422622_duci
duck115929172_duck
duct75735462_duct
dude65629662_dude
due45249862_du_e
duke95628102_duke
dunce86319262_dunce
dune56137582_dune
dupe76630602_dupe
dure56341812_dure
edge65719662ed_ge
edict84722282edict
edile64819492edile
educate10310212educate
educts9439892educts
elude64517622elude
elute54822572elute
endue64215352endu_e
endure74014142endure
enure53520222enure
eruct74022352eruct
etude63612302etude
exude134010292exude
induce93811532induce
luce65132572_luce
puce85127882_puce
reduced11610322reduced
reducer1059002reducer
reduces10513342reduces
sauce75121652sauce
seduced1186752seduced
seducer1056502seducer
seduces1069282seduces
truce75118692truce

Search took 2 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 Filter178691538000.0762351197.4
2DLD Change Limit53800561.69031834.3
3Display Results56560.0134307.7
 (SQL Overall)178691561.779100444.6
 
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.