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

184 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
gardened113700(None) 
gardener1037101gardener
hardened1338611hardened
burdened1236422burdened
careened1139192careened
darkened1435942darkened
gandered112211172gandered
garden84215082garden__
gardeners1136602gardeners
gardenia1045382gardenia
gardens93312092garden_s
garmented1345882garmented
garnered10247112garnered
garreted1057522garreted
gartered10319582gartered
gladdened1342582gladdened
greened93111262g_reened
hardener1238882hardener
harkened1637482harkened
ladened979052la_dened
maddened1334892maddened
pardoned12189332pardoned
saddened1135342saddened
sardined10268662sardined
addend9458453_adden_d
agreed84712503agr_e_ed
aliened81011743_aliened
ardency1346483_ardency
ardent73022613_arden_t
arene55329413_ar_ene_
arenes64928393_ar_enes
barbered13259543barbered
barded105426423bard__ed
barned95623583bar__ned
barreled1137843barreled
barrener1038333barrener
bartend1038753barten_d
bartended1344663bartended
bartered113113013bartered
battened11259573battened
bordered1248933bordered
brazened20134903brazened
burdener1136133burdener
cadenced1435523ca_denced
carded105424903card__ed
careener1039323careener
careered1139493careered
carpeted1338943carpeted
cartoned111312833cartoned
coarsened1245143coarsened
cordoned12229613cordoned
cravened1476713cravened
dampened1435623dampened
dandered112110963dandered
darkener1335993darkener
darned85018483dar__ned
davened124610073da_vened
deadened1137233deadened
earned74818333ear__ned
farded114518953fard__ed
fastened12257853fastened
fattened12268283fattened
gadded103913173ga_d_ded
gadrooned1243403gadrooned
gained84617463ga__ined
galleted1038213galleted
gammoned1444993gammoned
gangrened1242733gangrened
garaged1039253gar_aged
garbed104815663gar__bed
garbled114512803gar_bled
gardant9314463gardan_t
gardenful1442343gardenful
gardenias1145403gardenias
gardening1236513gardening
garganey1344883garganey
gargled104210673gar_gled
garland948703garlan_d
garlanded1244693garlanded
garment10315233garmen_t
garments1139963garments
garner73917003gar__ner
garnet73928413gar__net
garoted9710133gar_oted
garotted1066193garotted
garred85217403gar__red
garroted1056783garroted
gathered13149373gathered
gaveled12399133ga_veled
gendered11258873gendered
girded93712493gird__ed
girdled10217453gird_led
girned84010513gir__ned
gladdener1252403gladdener
glandered1236333glandered
goldener1045403goldener
gorgeted1135353gorgeted
gradated1157433gradated
graded94919553grad__ed
gradine93317033gradine_
gradines103615253gradines
grained93814273g_rained
graveled13417363graveled
greed75125693g_r_e_ed
greener83111713g_reener
greeted93111383g_reeted
greyed114610603g_r_eyed
grieved1235283g_rieved
grinned9378553g_rinned
groaned9259973g_roaned
groined92710813g_roined
grueled937133g_rueled
guarded1036153guard__ed
guerdoned1241923guerdoned
gyrene10227243gyr_ene_
gyrenes11267523gyr_enes
happened1635653happened
harden105718533harden__
hardeners1338083hardeners
hardens113815023harden_s
harkener1537573harkener
harshened1644453harshened
hastened12239103hastened
havened14429243ha_vened
hearkened1744453hearkened
heartened1347063heartened
hoarsened1344053hoarsened
hoidened1335653hoidened
hoydened1644643hoydened
jargoned1735233jargoned
laddered1136743laddered
larcener1036493larcener
larded84319093lard__ed
latened8711923la_tened
leadened1036153leadened
loudened1044693loudened
margented1346813margented
margined1237743margined
marketed1537323marketed
marooned1138563marooned
marveled1436433marveled
mildened1235773mildened
murdered1236023murdered
nardine82712573nardine_
ordered9108533_ordered
pandered121812573pandered
parceled1338323parceled
parcener1238463parcener
pardee93922023parde_e_
pardine103616723pardine_
pardner10239473pard_ner
pardoner11189443pardoner
parented11912213par_ented
pargeted1238673pargeted
parleyed1436213parleyed
pattened11299393pattened
preened103214983_preened
rattened9218623rattened
ravened115012283ra_vened
reddened1136423reddened
rehardened1543943rehardened
sarcenet10413313sarcenet
sardine83317393sardine_
sardines92815563sardines
sarsenet8412943sarsenet
screened1137403screened
sharpened1544473sharpened
smartened1244263smartened
soddened1144643soddened
targeted1037483targeted
tarweed1137343tarwe_ed
tautened935423tautened
wakened1546873wa_kened
wandered132110793wandered
warded115021043ward__ed
warden104515513warden__
wardenry1542973wardenry
wardens113711903warden_s
warned104018913war__ned
warrener1136913warrener
widened12328053_widened
worsened1236053worsened
yarded114714023yard__ed
yarned105514023yar__ned

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621847.28320068.9
3Display Results1841840.0632920.6
 (SQL Overall)1786911847.51623774.7
 
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.