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

223 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
garments113996(None) 
garment10315231garment_
sarments10311961sarments
varments1339061varments
aments85219802_a_ments
argents84014852_argents
armets84918352_arme_ts
arpents93613082_arpents
ferments13311472ferments
gardens93312092garden_s
gargets94614572garge_ts
garmented1345882garmented
garnets84115402garne_ts
garrets84413622garre_ts
gerents82612922ger_ents
germens1078632germen_s
laments94314852la_ments
margents11410132margents
paraments13511552paraments
parents93418122par_ents
payments1536942payments
raiments1039902raiments
sarment9318762sarment_
sarmenta1047722sarmenta
torments10310452torments
varment12313242varment_
varmints1335642varmints
absents93510723_absents
accents113511233_accents
advents11309473_advents
agents74816293_a_gents
agreements1345493agreements
ailments1039433ailments
aliments10311093aliments
amends94713283_a_mends
amens75624843_a_men_s
ament76036543_a_ment_
apartments1445703apartments
ardent73022613_ardent_
arenas65021993_ar_enas
arenes64928393_ar_enes
argent74023663_argent_
arguments1256573_arguments
armaments1347473_armaments
armers85520273_arme_rs
armet76739453_arme_t_
armings103811503_armings
armlets94610063_armlets
armpits1157133_armpits
armrests1055383_armrests
aroints7313133_aroints
aroynts1036633_aroynts
arpens84814823_arpen_s
arpent84822093_arpent_
arrests73312683_arrests
ascents93812553_ascents
assents74512223_assents
augments1137833augments
averments1449093averments
bailments1346463bailments
barbets114915843barbe_ts
barmen105418533barmen__
baronets101410903baronets
barrens94414323barren_s
barrets94917103barre_ts
bartends1136793bartends
basements1348263basements
brents84717273_br_ents
careens94514703careen_s
carets85330773car_e_ts
carmen104019343carmen__
carmines123617873carmines
carnets93918403carne_ts
carpets113915333carpe_ts
casements1348583casements
catmints1236663catmints
cements112714223_cements
cerements13411453cerements
cermets1139713cerme_ts
comments142913883comments
currents1038373currents
darkens12409873darken_s
debarments1545853debarments
dements103016623_dements
earnests837853earnests
easements11410333easements
elements10312173elements
farmers124315263farme_rs
farmings14298223farmings
ferment12315573ferment_
figments1446943figments
fitments1376793fitments
foments122912053_foments
formants13269953formants
fragments1546213fragments
furmenty1645293furmenty
gabfests1442383gabfests
gadgets10348683gadge_ts
gagmen103910413gagmen__
galenas83310343ga_lenas
gallants93310373gallants
gallets83517403galle_ts
gambits12399723ga_mbits
gameness112810693ga_meness
gamers94420833ga_me_rs
games86238553ga_me__s
gamest94919933ga_mest_
gamete9313593ga_me_te
gametes10312253ga_metes
gamines103618463ga_mines
gamings114610913ga_mings
gamins94420053ga_min_s
gammers123214563gamme_rs
gammons1237973gammon_s
gamuts958783ga_m_uts
gannets83811443ganne_ts
garcons102411643garcon_s
gardant9314463gardant_
garden84215083garden__
gardened1137003gardened
gardener1037103gardener
gardeners1136603gardeners
gardenia1045383gardenia
gardenias1145403gardenias
garget84327273garge_t_
gargety12388043garge_ty
garlands1038323garlands
garmenting1445483garmenting
garners83815983garne_rs
garnet73928413garne_t_
garret74426563garre_t_
garrons82713463garron_s
garters84218233garte_rs
garveys14124463garve_ys
gaskets12348153gaske_ts
gasmen93111563gasmen__
gents65729613g___ents
gerent73223103ger_ent_
germans1079473german_s
germen9612313germen__
gorgets94711783gorge_ts
gorhens1137183gorhen_s
gormands1266563gormands
gourmets1144153gourme_ts
grabens10367003graben_s
gradients1145273gradients
grants73722473g_r_ants
greats76318393g_r_eats
greens75716873g_reen_s
greenth11116723g_reenth
greenths1295213g_reenths
greets75117423g_r_eets
grunts75511853g_r_unts
guardants1143793guardants
gurnets84010793gurne_ts
gyrenes11267523gyr_enes
hardens113815023harden_s
hardiments1644533hardiments
harkens144112863harken_s
harmers124116593harme_rs
harmines132715143harmines
harmins123716723harmin_s
harvests14246173harvests
hutments1345603hutments
lament85024943la_ment_
latents75214313la_tents
ligaments1246203liga_ments
loments93413473_loments
mammets103911113mamme_ts
margent10316693margent_
markets133314033marke_ts
marmots11311513marm_ots
martens93714953marten_s
maumets11369693maume_ts
moments113113123_moments
mordents1138813mordents
oddments1244103oddments
orients7311583_orients
parament12415393parament_
paramenta1368863paramenta
parchments1944983parchments
parent83230423par_ent_
pargets105215193parge_ts
parvenus1335653parvenus
patents94815203pa_tents
patients1088763patients
pavements1647003pavements
payment14310703payment_
percents122713373percents
perpents122312043perpents
pigments1337343pigments
portents103512823portents
raiment9315413raiment_
ramenta9311183ra_menta
ramets83517393ra_me_ts
rents55935183__r_ents
rerents73319423rer_ents
sacraments1445853sacraments
salients839563salients
sapients1037423sapients
sarcenets1146953sarcenets
sarmentum1343643sarmentum
sarsenets946513sarsenets
sarsens7311393sarsen_s
sarsnets836783sarsnets
segments1138903segments
serpents102410373serpents
sorbents10279133sorbents
talents7312013ta_lents
tangents938713tangents
targets84314223targe_ts
torment9316173torment_
torrents838143torrents
variants1139203variants
varlets10411573varle_ts
varmint12311683varmint_
wardens113711903warden_s
warmers124514293warme_rs
warmest123113033warmest_
warmness1337063warmness
warrants1168503warrants
warrens103810893warren_s
yamens114010823ya_men_s

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.436409841.7
2DLD Change Limit1461622237.20320291.8
3Display Results2232230.0962322.9
 (SQL Overall)1786912237.73523101.6
 
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.