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

149 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
gardener103710(None) 
gardened1137001gardened
gardeners1136601gardeners
hardener1238881hardener
barrener1038332barrener
burdener1136142burdener
careener1039332careener
darkener1335992darkener
garden84215082garden__
gardenia1045382gardenia
gardens93312092garden_s
garner73917002gar__ner
gladdener1252402gladdener
goldener1045402goldener
greener83111712g_reener
hardened1338612hardened
hardeners1338082hardeners
harkener1537572harkener
larcener1036492larcener
parcener1238472parcener
pardner10239472pard_ner
pardoner11189442pardoner
warrener1136912warrener
aliener71011193_aliener
ardency1346483_ardency
ardent73022613_arden_t
arene55329413_ar_ene_
arenes64928393_ar_enes
bartender1244603bartender
barterer102711633barterer
battener10369393battener
borderer1168103borderer
burdened1236423burdened
burdeners1245063burdeners
carder94524183card__er
careened1139193careened
careeners1138543careeners
career85822243car_e_er
careerer1038583careerer
carpenter1346503carpenter
dampener1335533dampener
darkened1435943darkened
darkeners1435153darkeners
darneder1033983darneder
darner74017303dar__ner
deadener1036743deadener
earner63617223ear__ner
fastener11227833fastener
fattener11268113fattener
gadder93714713ga_d_der
gainer74117493ga__iner
gammoner1345153gammoner
gander84322763gand__er
gandered112211173gandered
garbler104012563gar_bler
gardant9314463gardan_t
gardenful1442353gardenful
gardenias1145403gardenias
gardening1236513gardening
garganey1344883garganey
gargler93710263gar_gler
garment10315233garmen_t
garmented1345883garmented
garments1139963garments
garnered10247113garnered
garners83815983gar__ners
garnet73928413gar__net
garotter965943garotter
garreted1057523garreted
garroter956573garroter
garter74420513gar__ter
gartered10319583gartered
gatherer12147903gatherer
gaudier938453gaud_ier
girder84312063gird__er
girdler9227313gird_ler
gladdened1342583gladdened
gladdeners1352063gladdeners
grader84919693grad__er
gradine93317033gradine_
gradines103615253gradines
grainer83714063g_rainer
greened93111263g_reened
greenery12265923g_reenery
greenier938713g_reenier
greeter82812673g_reeter
greyer104510093g_r_eyer
griever1136033g_riever
grinner8329233g_rinner
groaner82510133g_roaner
grueler837023g_rueler
guarder936463guard__er
gyrene10227243gyr_ene_
gyrenes11267523gyr_enes
harden105718533harden__
hardens113815023harden_s
harder105022403hard__er
hardier114721543hard_ier
harkened1637483harkened
harkeners1636073harkeners
hastener11259133hastener
hearkener1644213hearkener
heartener1256763heartener
ladened979053la_dened
larceners1135993larceners
larder73720973lard__er
lardier83518343lard_ier
lateener835763lateener
maddened1334893maddened
mariner93315993mar_iner
marketer1437383marketer
murderer1145263murderer
nardine82712573nardine_
orderer8127943_orderer
panderer112210913panderer
parceners1337453parceners
pardee93922023parde_e_
pardine103616723pardine_
pardners11269193pard_ners
pardoned12189333pardoned
pardoners12208213pardoners
parleyer1335633parleyer
partner92811393par_tner
preener93114833_preener
rattener8238533rattener
ravener104110743ra_vener
saddened1135343saddened
sarcenet10413313sarcenet
sardine83317393sardine_
sardined10268663sardined
sardines92815563sardines
sarsenet8412943sarsenet
screener1037573screener
serener73415763ser_ener
sharpener1444583sharpener
tardier859719993tard_ier
verderer1245373verderer
wakener1446913wa_kener
wanderer122210123wanderer
warden104515513warden__
wardenry1542973wardenry
wardens113711903warden_s
warder104020273ward__er
warner93717223war__ner
warreners1236193warreners
widener11318693_widener
woodener1245763woodener
yarder103813973yard__er
yarner93313063yar__ner

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621496.28323263.1
3Display Results1491490.0602483.3
 (SQL Overall)1786911496.74926476.7
 
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.