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

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

138 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
doucely134488(None) 
deucedly1543542deucedly
doubly12328962dou_bly
douce85518422douce__
douceur1043112douceur
dourly103210432dou_rly
acutely1246123acutely
bluely113310083blu_ely
boucle103712783bouc_le
boucles113113003boucles
bouncily1544383bouncily
brutely1235933brutely
choicely1843823choicely
cicely1338833_cicely
comely134213733co_mely
courtly1256923courtly
crousely1346563crousely
crudely1336273crudely
cutely115312803_cutely
daubery13396213daubery
demurely1443933demurely
densely1146713densely
deuce84517493deuce__
deuced104112123deuce_d
deuces94015513deuce_s
dicey114819333d_ice_y
direly10311563d_irely
docent92918683do_cent
docile94213123do_cile
docilely1443993docilely
doddery13516853doddery
dodgery13627783dodgery
dogey105719513do_ge_y
doggedly1543103doggedly
doggery13448263doggery
doily95321033do__ily
dolce85816683dolce__
dolly96125203do__lly
donkey14449733donke_y
donzel1636313donzel_
donzels1735393donzels
dooly94821803do__oly
doomily1336133doomily
dopey116020353do_pe_y
dopily123510463do_pily
dorsel75315503dorsel_
dorsels84412573dorsels
dossel74813643dossel_
dossels85511603dossels
dottel73610893dottel_
dottels8327783dottels
dottily1147283dottily
double94013993dou_ble
doubled11289953doubled
doubler103110083doubler
doubles103113353doubles
doublet103914033doublet
douceurs1142793douceurs
douche124613223douc_he
douched144012113douched
douches134315233douches
doughty15436023doughty
doughy14499843dou_ghy
doula65717773dou__la
dourer74215273doure_r
dourest8312943dourest
douse66329723douse__
doused84821163douse_d
douser75621633douse_r
dousers84817273dousers
douses74928933douse_s
dowdily1534953dowdily
dowel95618193do_wel_
dowels104813343do_wels
dowery134311663do_wery
doyley13487283doyle_y
doyly124514013do__yly
dozily19329103do_zily
drumly1235703dru_mly
dually103210063d_ually
ducal84816423d_ucal_
ducally13257413d_ucally
duce76933503d_uce__
duces86327473d_uce_s
duchy144310873d_uc_hy
ducky154216113d_uc_ky
duel56729703d_u_el_
duels65619233d_u_els
dulcetly1443023dulcetly
dully94921633d_u_lly
duly85323033d_u__ly
dumbly14399603d_umbly
duopoly1343683duopoly
dupery12378743d_upery
forcedly1744793forcedly
foully1239013fou_lly
gauchely1742743gauchely
goutily1137933goutily
homely145313173ho_mely
hourly12369623hou_rly
housefly1744103housefly
housel95217043housel_
housels105312133housels
hugely1336803_hugely
knuckly1542473knuckly
lonely92912473lo_nely
loosely1036713loosely
loudly1037783lou_dly
lousily1038333lousily
lovely12339713lo_vely
mousey115216193mouse_y
mousily1239393mousily
muchly1686203_muchly
mutely113811653_mutely
nicely1139493_nicely
nudely10299033_nudely
ousel55222403_ousel_
ousels64815273_ousels
outfly1238273_outfly
ouzel144612323_ouzel_
ouzels15408703_ouzels
pouchy16538663pouc_hy
purely114013623_purely
roughly14507293roughly
roundly1136723roundly
roupily1246653roupily
rudely10389973_rudely
saucily1237913saucily
solely93714213so_lely
sorcery1237033sorcery
sorely94618013so_rely
soundly1136683soundly
sourly93612213sou_rly
sprucely1543123sprucely
surely93816463_surely
touchily1645233touchily
touchy145010503touc_hy
toughly14487433toughly

Search took 7 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271386.75019855.9
3Display Results1381380.0463000.0
 (SQL Overall)1786911386.93625762.8
 
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.