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

164 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
roulade85699(None) 
roulades957161roulades
couvade1335062couvade
moulage1037902moulage
poularde11276572poularde
remoulade1243262remoulade
rosulate8310902rosulate
adulate8313233adulate
alulae6312743alula_e
aoudad835033aoudad_
aoudads973753aoudads
aubade939223_aubade
ballade104012563ballade
blade85923333__blade
bolide9515563bo_lide
boulder103411343boul_der
boule74828043boul__e
boulle84614613boul_le
brocade1238533bro_cade
clade85821013__clade
cockade1638133cockade
collage102813753collage
collate92919683collate
collide103214783collide
collude10337983collude
comade114415323co_made
comrade12139213comrade
copulae112810613copula_e
copulate122614113copulate
corrade101111043corrade
coude85022633cou__de
could86517713coul_d_
coulee8323503coul_ee
courage10310993courage
couvades1435603couvades
croustade1243943croustade
crusade1036053crusade
doula65717773doula__
doulas75114993doula_s
emulate9314123emulate
folate93320393fo_late
forbade13259103forbade
foulard11257283foulard
foulards12266463foulards
fouled104315973fouled_
glade75121963__glade
goulash1164273goulash
gourde8107933gou_rde
grillade1085143grillade
haulage1136913haulage
hollaed11359853hollaed
inulase739413inulase
joule124918203joul__e
lade56345983___lade
lobulate1078833lobulate
loculate101011403loculate
modulate1138593modulate
morulae958963morula_e
moulages1138053moulages
mould86015753moul_d_
moulded11348063moul_ded
moulder10389803moul_der
moulds94910993moul_ds
mouldy12437413moul_dy
moulted103310313moulted
noplace1137393noplace
noyade1036423no_yade
oblate82214743_oblate
outadd837803_outadd
outage72017533_outage
outate62923403_outate
ovulate1039453ovulate
pomade113611333po_made
populace14256253populace
populate122812093populate
poulard10299733poulard
poulardes12286183poulardes
poulards11288233poulards
prograde1247183prograde
prolate9419793pro_late
protrade1148213protrade
radulae837963radula_e
reclad9311873reclad_
reclads1049993reclads
reclame11411063reclame
reflate103516263reflate
reglaze1747223reglaze
regrade92612033regrade
regulate9313023regulate
relace83122153r_elace
relate64033633r_elate
remade94316983r_emade
remolade1147203remolade
remoulades1343183remoulades
replace113214283replace
replate93420053replate
reslate73520593reslate
respade1039573respade
road56332113ro__ad_
roadeo7510323ro__adeo
roadie72813803ro__adie
roads66523613ro__ads
roble75223023robl__e
rode55844303ro___de
rodlike1288263rodlike
roiled74320053roiled_
role45851823ro_l__e
rolfed104510523ro_lfed
rolled74220243rolled_
rootage839043rootage
roseate7613453roseate
rotate63320343ro_tate
rouble83913313rou_ble
rouche114714313rou_che
roue45941743rou___e
rouge65423443rou__ge
rouged86717323rouged_
roughage1344423roughage
roughed124210943roughed
rouille737493rouille
rouleau746823rouleau
rouleaus844973rouleaus
rouleaux1542473rouleaux
roulette847093roulette
round64318433rou_nd_
rounded93013503rou_nded
roundel8308853rou_ndel
rounder83514593rou_nder
rounds73615613rou_nds
rouped95717353rouped_
rouse56634703rou__se
roused75426443roused_
rousted84013323rousted
route55132073rou__te
routed75624333routed_
routine72615903routine
rubace10310173r_ubace
rude55632783r_u__de
rugae65114763r_uga_e
rugate75813813r_ugate
rulable9310533r_ulable
rule49938423r_ul__e
ruled65822523r_uled_
scalade10359263scalade
soilage8169353soilage
solace83415823so_lace
solate64526073so_late
souled75419823souled_
soulmate1047183soulmate
soutane7312063soutane
tolane64316583to_lane
tollage82610163tollage
toluate7159343toluate
toluide835263toluide
torsade837593torsade
torulae758553torula_e
tuladi765723_tuladi
ululate749963ululate
unlade72714153_unlade
uvulae945323uvula_e
vorlage1136403vorlage
would95513153woul_d_
zonulae1645963zonula_e
zouave1833573zou_ave

Search took 8 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.1561145455.1
2DLD Change Limit1340271647.12618808.2
3Display Results1641640.0602733.3
 (SQL Overall)1786911647.34224338.2
 
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.