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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
douce8551842(None) 
deuce84517491deuce
dolce85816681dolce
douche124613221douche
douse66329721douse
duce76933501d_uce
adduce1076452adduce
bocce114313112bocce
boucle103712782boucle
boule74828042boule
bounce104014832bounce
bouse75931852bouse
couch125320112couch
coude85022632coude
coupe96023482coupe
dace76934922d_ace
dance85223132dance
daube85015302daube
deduce1079252deduce
deice84320032deice
deuced104112122deuced
deuces94015512deuces
dice75841892d_ice
dobie84920322dobie
doc66841512do_c_
dock116228742do_ck
docs75631152do_cs
dodge86618122dodge
doe47361952do__e
doge66233802do_ge
dogie75222792dogie
dolci84912602dolci
dole56550002do_le
dome77240732do_me
done55747912do_ne
donee66931012donee
donne65520462donne
dope76038892do_pe
dore56353302do_re
dose56442432do_se
dote55442882do_te
double94013992double
doubt8720092doubt
doucely1344882doucely
douceur1043112douceur
douched144012112douched
douches134315232douches
dough105217382dough
doula65717772doula
doum76226672dou_m
douma85817702douma
doums85417642doums
dour56330432dou_r
doura66518662doura
dourer74215272dourer
doused84821162doused
douser75621632douser
douses74928932douses
doux125817982dou_x
dove85131562do_ve
dowie94721142dowie
dowse96020812dowse
doxie136017152doxie
doze145829082do_ze
drupe85012992drupe
druse64817662druse
duces86327472d_uces
duci76422622d_uci
duck115929172d_uck
duct75735462d_uct
dude65629662d_ude
due45249862d_u_e
duke95628102d_uke
dunce86319262dunce
dune56137582d_une
dupe76630602d_upe
dure56341812d_ure
educe84313452educe
force105324272force
gouge78220062gouge
house89131422house
joule124918202joule
jounce153310732jounce
louche115212662louche
louie55023512louie
loupe75319512loupe
louse56131012louse
luce65132572_luce
mouch124715802mouch
moue65835572mou_e
mouse77133002mouse
nonce75719822nonce
once65423082_once
ouch95724632_ouch
ounce77019932_ounce
ponce95222512ponce
pouch124617082pouch
pounce105214092pounce
puce85127882_puce
rouche114714312rouche
roue45941742rou_e
rouge65423442rouge
rouse56634702rouse
route55132072route
sauce75121652sauce
source8410672source
souse56530772souse
touch106519392touch
touche114916172touche
touse55430672touse
truce75118692truce
voice104915322voice
vouch134611902vouch
youse85322232youse

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.0961861364.6
2DLD Change Limit538001141.54634799.5
3Display Results1141140.0303800.0
 (SQL Overall)1786911141.672106872.6
 
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.