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

142 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
gardening123651(None) 
hardening1438021hardening
burdening1335542burdening
careening12310012careening
darkening1535682darkening
gandering122111292gandering
gardenia1045382gardeni_a
gardenias1145402gardenias
garmenting1445482garmenting
garnering11298082garnering
gartering112111572gartering
gladdening1442692gladdening
greening103112532g_reening
hardenings1544242hardenings
harkening1746922harkening
ladening1078822la_dening
maddening1445112maddening
pardoning1338762pardoning
saddening1245212saddening
sardining1137572sardining
adenine8311213_a_denine
agreeing10295903agr_eeing
aliening91510893_aliening
barbering14229683barbering
barding113822893bard__ing
barning104320353bar__ning
barreling1238043barreling
bartending1444913bartending
bartering122313643bartering
battening12268853battening
bordering1338833bordering
brazening2185183brazening
cadencing1544963ca_dencing
carding113922433card__ing
careering12311203careering
carpeting1439483carpeting
cartoning12311113cartoning
coarsening1345543coarsening
cordoning1338063cordoning
cravening1547553cravening
dampening1535463dampening
dandering122511063dandering
darning93817333dar__ning
davening13258873da_vening
deadening1277583deadening
earning83418213ear__ning
farding123716743fard__ing
farseeing1344383farseeing
fastening13268603fastening
fattening13287833fattening
gadding113411453ga_d_ding
gadrooning1343543gadrooning
gaeing84617223ga__e_ing
gaining94015663ga__ining
galleting1137633galleting
gammoning1545063gammoning
gangrening1342773gangrening
garaging1139043gar_aging
garbing113613273gar__bing
garbling12249453gar_bling
garden84215083garde__n_
gardened1137003garden_ed
gardener1037103garden_er
gardeners1136603gardeners
gardenful1442353gardenful
gardens93312093garde__ns
gargling11239203gar_gling
garlanding1344433garlanding
garoting10510703gar_oting
garotting1136103garotting
garring93116713gar__ring
garroting1136953garroting
gathering1499463gathering
gaveling133410163ga_veling
gendering12249753gendering
girding103611883gird__ing
girdling1146823gird_ling
girning93210693gir__ning
gradating1237313gradating
grading103918713grad__ing
graining102813183g_raining
graveling1457383graveling
greeing93613783g_r_eeing
greenings11266663g_reenings
greenling1136753g_reenling
greenwing1434693g_reenwing
greeting103112353g_reeting
greying124110893g_r_eying
grieving1385893g_rieving
grinning1037863g_rinning
groaning102410283g_roaning
groining102310633g_roining
grueling1078273g_rueling
guarding1136523guard__ing
guerdoning1362363guerdoning
happening1735593happening
harshening1744173harshening
hastening13259483hastening
havening15258553ha_vening
hearkening1844533hearkening
heartening1446733heartening
hoarsening1444403hoarsening
hoidening1435633hoidening
hoydening1744353hoydening
jargoning1845983jargoning
laddering1237593laddering
larding92917873lard__ing
latening9711493la_tening
leadening1176733leadening
loudening1144743loudening
margenting1446153margenting
margining1337603margining
marketing1636513marketing
marooning1238593marooning
marveling1537103marveling
mildening1345673mildening
murdering1357133murdering
ordering1039353_ordering
pandering133211963pandering
parceling1438443parceling
parenting12611583par_enting
pargeting1338283pargeting
parleying1536113parleying
preening113115843_preening
rattening10288763rattening
ravening122611293ra_vening
reddening1237433reddening
rehardening1644143rehardening
screening1247193screening
sharpening1644883sharpening
smartening1344993smartening
soddening1244543soddening
targeting1137303targeting
tautening1035843tautening
wakening1636323wa_kening
wandering143310983wandering
warding123918143ward__ing
warning113717093war__ning
widening13237833_widening
worsening1345553worsening
yarding123413143yard__ing
yarning113512953yar__ning

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 Filter1786911486410.470380193.6
2DLD Change Limit1486411426.65622331.9
3Display Results1421420.0632254.0
 (SQL Overall)1786911427.18924856.2
 
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.