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

424 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
gentler837895(None) 
gentle74014511gentle_
gentled9389091gentled
gentles83714341gentles
antler64615552_antler
beetler938042beetler
center84421412cent_er
centner946852centner
enter54726382_ent_er
gantlet83616242gantlet
gender83517932gen_der
genteel836752genteel
genteeler1043092genteeler
gentes75324162gent_es
gentile83515292gentile_
gentiles93713522gentiles
gentlest93410572gentlest
gently103710912gentl_y
getter74117612ge_tter
guttler8369162guttler
nestler73510452nestler
nettler7349502nettler
renter64527412rent_er
rentier73618222rentier
settler73410652settler
tenter64623932tent_er
tentier73815922tentier
venter94218722vent_er
aether94213673ae_ther
agented939423agent_ed
angler74017863_angler
anther93715063_anther
antlers74014743_antlers
auntlier834903auntlier
banter84825333bant_er
battler94113383battler
beater84729393beat_er
beetle8311673beetle_
beetled1038223beetled
beetlers1037403beetlers
beetles9312083beetles
belter84720963belt_er
bencher144113483bencher
bender95223303ben_der
bendier103111413bendier
better84723703be_tter
beveler124010693beveler
bottler94211883bottler
bundler104011723bundler
bungler104611483bungler
bunter85020383bunt_er
bustler94012573bustler
butler84220033_butler
candler103516593candler
canter85230113cant_er
cantle84522153cantle_
cantles94721413cantles
ceiler84013963ce_iler
censer84516583cen_ser
centare93113703centare
centaur935783centaur
centers94420603cent_ers
centile94217183centile_
centiles103615813centiles
centners1057243centners
centraler1146683centraler
centre84316643centre_
centred103411683centred
centres93817123centres
cutler84718033_cutler
dandler94414273dandler
dangler96912813dangler
dealer74122143de_aler
defiler113911883defiler
defter104215923deft_er
denier74420693den_ier
denser74115193den_ser
dented84120513dent_ed
dentiled1039743dentiled
denture8311893denture
denuder9167603denuder
deter65028043de_t_er
dexter143810893dext_er
eater54639843_eat_er
either94517423_either
enabler9299363_enabler
ender64325863_en_der
entailer877833_entailer
entera64216833_ent_era
enterer72015633_enterer
enters64425643_ent_ers
enticer91510423_enticer
entire61617703_entire
entree61817883_entree
envier939673_envier
ester54727713_est_er
ether84518773_e_ther
eviler94811893_eviler
exiler134712183_exiler
feater95224053feat_er
feather133613503feather
featlier1136453featlier
feebler1235823feebler
feeler93215173fe_eler
feller94419553fe_ller
fencer114613533fen_cer
fender103718723fen_der
fennier10339253fennier
fester94723513fest_er
fetter94120383fe_tter
fettle93713123fettle_
fettled11378933fettled
fettles103912733fettles
fondler11348883fondler
footler104011873footler
gabbler124013303gabbler
gaiter73819503gait_er
gambler123612683gambler
gander84322763gan_der
ganger83721463gan_ger
ganglier1047603ganglier
gantlets9308903gantlets
gaoler73913573g_aoler
garbler104012563garbler
gargler93710263gargler
garter74420513gart_er
gaster75027353gast_er
gater64533653g_at_er
gather104115863g_ather
gaunter82910713gaunt_er
gauntlet955903gauntlet
geekier12286393geekier
geezer16278013ge_ezer
gelder84613713ge_lder
gelee63626983ge__lee
gelled84718893ge_lled
gemmier12337383gemmier
genders93616783gen_ders
gene56237223gen__e_
genera71211713gen__era
genes65133093gen__es
geneses82613523geneses
genet66038683gen__et
genette838863genette_
genettes938303genettes
genie66124923gen_ie_
genies75324943gen_ies
genitor837273genitor
geniture946453geniture
gennaker1342923gennaker
genome94312193genome_
genomes103611703genomes
genre66016803gen_re_
genres75515623gen_res
gent56954393gent___
gentian8310103gentian
gentil74115123gent_il
gentleman1242833gentleman
gentlemen1243853gentlemen
gentling1048453gentling
gentoo7311313gent_oo
gentoos838633gentoos
gentries91315263gentries
gentry103410443gent_ry
gents65729613gent__s
genuses83510883genuses
germier10309543germier
geste65920693gest_e_
gestes75721393gest_es
gesture839243gesture
gesturer935983gesturer
getters84216103ge_tters
geyser1036513ge_yser
giggler101029883giggler
giller74519733g_iller
ginger84920033gin_ger
ginner73915823gin_ner
ginnier8298983ginnier
girdler9227313girdler
gleetier934913gleetier
glintier945703glintier
glitter84211803glitter
gnawer10386953g_nawer
gobbler123310023gobbler
goggler10379323goggler
goiter74116203goit_er
goner66025163gon__er
goutier82612353goutier
granter84117133grant_er
grater74625443grat_er
greater84416493great_er
greeter82812673greet_er
griller84513353griller
gritter83913353gritter
growler11318973growler
grueler837023grueler
grunter83110783grunt_er
gruntle8257053gruntle_
gruntled10274943gruntled
gruntles9287233gruntles
gunkier12369553gunkier
gunner73813983gun_ner
gustier83813863gustier
gutter73817713g_utter
guttier83911103guttier
guttle74111973guttle_
guttled9378993guttled
guttlers9306933guttlers
guttles83011933guttles
guzzler16286563guzzler
handler113516163handler
hantle94318203hantle_
hantles104117513hantles
healer94221803he_aler
heater94828303heat_er
heather133914853heather
heckler16278573heckler
heeler93917313he_eler
hefter124313923heft_er
heftier1337203heftier
heller93322513he_ller
henley1237483hen_ley
hented104218753hent_ed
hinter94021303hint_er
hostler103411023hostler
hunter94817773hunt_er
hustler103410753hustler
inter55028493_int_er
jangler153811833jangler
jester134319153jest_er
jettier14358693jettier
jeweler1735053jeweler
jingler154311093jingler
jostler14288223jostler
kegeler1245493kegeler
kegler11398243ke_gler
kelter103214383kelt_er
kente95821073kent_e_
kentes105118653kent_es
kettle104311613kettle_
kettles113411613kettles
kindler12309983kindler
kittler11338163kittler
kneeler11277573kneeler
landler84113203landler
leather103815783leather
lefter93613433left_er
lender73921273len_der
lenten6312883lent_en
letter63722583le_tter
leveler10399903leveler
linter64625343lint_er
lintier73613803lintier
littler7348553littler
mangler103215643mangler
mantle84420923mantle_
mantled104113393mantled
mantles94820703mantles
mantlet93620993mantlet
meatier93214613meatier
meddler11319953meddler
meeter83616503meet_er
melter83520113melt_er
menacer112610883menacer
mender93520793men_der
mentee84121293ment_ee
mentees93214503mentees
mentor8414363ment_or
meter75130323me_t_er
metier83517693me_tier
mettle83815723mettle_
mettled103510543mettled
mettles94115023mettles
mewler113510233me_wler
mingler104213843mingler
minter84425103mint_er
mintier93615993mintier
mottler94410343mottler
neater64424313neat_er
needler8388893needler
neither1037573neither
nester64124183nest_er
nestle63013953nestle_
nestled8349913nestled
nestlers8359233nestlers
nestles73015463nestles
nether94014163ne_ther
netter63722023ne_tter
nettier74211813nettier
nettle64514583nettle_
nettled8339943nettled
nettlers8307513nettlers
nettles73214083nettles
nettlier864813nettlier
neuter63713793neut_er
ostler63312193_ostler
panther12611443panther
pearler9310373pearler
peatier94017233peatier
pedaler103410693pedaler
peddler113210493peddler
pedler93614623pe_dler
peeler83517383pe_eler
pelter83321623pelt_er
penciler1237113penciler
penile82219603penile_
penner84616663pen_ner
penster92811953penster
peopler1138083peopler
perter84422283pert_er
pester84827593pest_er
pestier94317403pestier
pestle83215843pestle_
pestled102711453pestled
pestles93217693pestles
peter74427593pe_t_er
petter83924773pe_tter
pettier94213613pettier
pettle84116053pettle_
pettled103611513pettled
pettles93916483pettles
pewter114013673pewt_er
pintle83818263pintle_
pintles94118723pintles
punter84320023punt_er
ranter63826823rant_er
rattler74012743rattler
realer63528593re_aler
realter73716313realter
reeler63822573re_eler
reenter73217793reent_er
regaler83814623regaler
reinter73116843reint_er
render74024143ren_der
reneger8299493reneger
renewer10248693renewer
rente54733783rent_e_
rented74426593rent_ed
renters74224813rent_ers
rentes65431193rent_es
rentiers83311763rentiers
rester63832433rest_er
reutter71010093reutter
reveler104116343reveler
reviler104314973reviler
runtier73512853runtier
rustler73512343rustler
sealer63928963se_aler
seater64534163seat_er
seller63824603se_ller
seltzer1635213seltzer
sender73824413sen_der
senile63420213senile_
seniles72618023seniles
sente56432883sent_e_
setter64023723se_tter
settle63915663settle_
settled83210873settled
settlers8289023settlers
settles73916003settles
settlor7314733settlor
sinter63625923sint_er
sneller73512853sneller
subtler92910843subtler
sutler63718393_sutler
tangler83515073tangler
tattler73112213tattler
teeter65420313teet_er
teether10349693teether
teller63519823te_ller
tender74121843ten_der
tenner64117103ten_ner
tenoner739683tenoner
tenser64919433ten_ser
tented74221003tent_ed
tenters73921103tent_ers
tentie62521183tentie_
tentless8229843tentless
tester64227153test_er
testier74015643testier
tether93716103te_ther
tetter64322453te_tter
tingler83613343tingler
tinkler113610543tinkler
tinter63923643tint_er
tootler73511123tootler
turtler72610323turtler
ungentle946573ungentle_
vealer94016543ve_aler
veiler93814353ve_iler
vender103418423ven_der
veneer94511693ven_eer
venomer1237583venomer
vented104617923vent_ed
venters103717733vent_ers
ventless11249053ventless
venture10311173venture
venturer1137243venturer
venular1037683venular
venule94411763venule_
venules104011483venules
vetoer93410063ve_toer
vetter93417643ve_tter
vintner1034833vintner
wangler113312653wangler
wanter94423053want_er
weather133513223weather
welter93417383welt_er
wencher153811133wencher
wennier10318603wennier
wester94222893west_er
wether123315393we_ther
wetter93919443we_tter
winter94222803wint_er
wintle94014603wintle_
wintled11339843wintled
wintles103414983wintles
wrestler11306993wrestler
yeller94214513ye_ller
yente86220043yent_e_
yentes95517603yent_es
yester93417983yest_er
zester153617793zest_er
zestier163010223zestier

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.423422437.4
2DLD Change Limit1340274246.50020619.5
3Display Results4244240.1562717.9
 (SQL Overall)1786914247.07925242.4
 
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.