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

446 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
lathery13391112(None) 
lather95124351lather_
lathers104321881lathers
leathery14438971leathery
bather115322512bather_
bathers124720362bathers
battery124911812battery
blather125314202blather_
blathers134713792blathers
cattery123811602cattery
clattery13378192clattery
dithery14318942dithery
eatery95316352eat_ery
father125116712father_
fatherly1745072fatherly
fathers133916502fathers
feathery17368072feathery
flattery14338292flattery
gather104115852gather_
gathers114315072gathers
hatchery19326382hatchery
heathery17349082heathery
lasher94824532lasher_
lashers104121832lashers
lately93413842lat_ely
later54843922lat_er_
lathe85626712lathe__
lathed104718452lathe_d
lathered121512322lathered
latherer111310442latherer
lathes95127492lathe_s
lathier10310832lathier_
lathy115215062lath__y
latter65027892latter_
latterly1136062latterly
leather103815782leather_
leathern11398912leathern
leathers114215082leathers
lechery15257642lechery
lithely1356642lithely
lither94520952lither_
littery103710492littery
loather103711002loather_
loathers113310442loathers
lottery10389832lottery
luthern1037652luthern
mattery123810712mattery
mothery153710512mothery
rather94319742rather_
slather103816072slather_
slathers113914782slathers
slithery14356702slithery
watery123914492wat_ery
abhenry1543333_abhenry
adhere10310333_adhere
aery77231683_a__ery
aether94213673aether_
aethers103614943aethers
alchemy1743113alchemy
alter54828503alt_er_
alters64924223alt_ers
althea938193althe_a
altheas1038223altheas
althorn1047763althorn
ambery133811133_ambery
anther93715063anther_
anthers103715203anthers
apery106517903_a_pery
archery15478063archery
artery9911453_artery
astheny1345293astheny
bakery155911003ba_kery
basher115123813basher_
bashers124820833bashers
batcher144414853batcher_
batchers153613273batchers
bathe105822883bathe__
bathed125518743bathe_d
bathes116524833bathe_s
batter84928873batter_
batters94626013batters
bitchery18236563bitchery
bladdery15344583bladdery
blathered15168353blathered
blatherer14176713blatherer
blatter94415653blatter_
blatters104414093blatters
blether12459913blether_
blethers13429613blethers
blithely16104033blithely
blither124812173blither_
blithers134711233blithers
botchery18366763botchery
bother115218063bother_
bothers124317753bothers
butchery18326253butchery
butlery12369423butlery
buttery124311193buttery
cachexy2443283cachexy
cannery123610013cannery
catcher143115823catcher_
catchers153114063catchers
cater74840723cat_er_
caters85336503cat_ers
cathead1338753cathead
cathect1439863cathect
cathedra14104773cathedra
cautery12349593cautery
chattery16357273chattery
cither114616683cither_
cithern12489913cithern
cithers124315773cithers
clasher124615513clasher_
clashers134213993clashers
clatter94014973clatter_
clatters103313913clatters
cluttery13346323cluttery
cutchery18265173cutchery
cutlery12448393cutlery
dasher104318983dasher_
dashers115016863dashers
datary10310243dat_ary
dater65332313dat_er_
daters74827373dat_ers
daubery13396213daubery
diathermy1842573diathermy
dither104417683dither_
dithers114016153dithers
eater54639843eat_er_
eaters65535953eat_ers
either94517423either_
elater64724203elat_er_
elaters74420193elat_ers
ether84518773_ether_
ethers94518413_ethers
faery116015483fa__ery
fakery16509263fa_kery
farther1348343farther_
fathead1437863fathead
fathered151510433fathered
fatter94523213fatter_
feather133613503feather_
feathers143513243feathers
fishery16397733fishery
flackery20295243flackery
flasher133914063flasher_
flashers143912653flashers
flathead1535803flathead
flatter103815963flatter_
flatters113814203flatters
fluttery14376143fluttery
gallery11468743gallery
gasher104320373gasher_
gater64533653gat_er_
gaters74728643gat_ers
gathered13149373gathered
gatherer12147903gatherer
gaudery1234743gaudery
glaziery21413693glaziery
glittery12375613glittery
goatherd1335263goatherd
guttery11427763guttery
hatcher153314723hatcher_
hatchers163113173hatchers
hater85034753hat_er_
haters94930403hat_ers
hatter94724873hatter_
hatters104221523hatters
heathenry1843403heathenry
heather133914853heather_
heathers143914733heathers
hither124417253hither_
ither84617603_ither_
jaggery19336903jaggery
jagghery2351803jagghery
japery18439143ja_pery
jaspery19405253jaspery
jittery17346443jittery
kasher134915033kasher_
kashers143914023kashers
laager74312783laager_
laagers83411253laagers
lacer75833753la_cer_
lacers85225253la_cers
lacey105820913la_ce_y
laches116528343lache_s
lacier84020093lacier_
lacker125325623lacker_
lackers134120543lackers
lackey154813353lacke_y
lactary1237843lactary
ladder84617623ladder_
ladders94115173ladders
lader65633723la_der_
laders74927763la_ders
ladler74314933ladler_
ladlers84613563ladlers
lager65132863la_ger_
lagers74826143la_gers
lagger85919833lagger_
laggers94216243laggers
lahar83114263la_har_
lahars94013163la_hars
laithly1335653laith_ly
laker95432873la_ker_
lakers105225153la_kers
lakier104716273lakier_
lamasery1343953lamasery
lamber104418493lamber_
lambers113817113lambers
lambert113617113lambert
lamely114013223la_mely
lamer75233703la_mer_
lampers113817333lampers
lamprey1434863lamprey
lancer84319973lancer_
lancers93616643lancers
lander74028483lander_
landers84026213landers
lanely93914483la_nely
laniary1068013laniary
lanker104123003lanker_
lanner64920603lanner_
lanners73618333lanners
lantern7310013lantern
lanthorn1147193lanthorn
lapper104319953lapper_
lappers113717463lappers
lapser84113143lapser_
lapsers93911053lapsers
larceny1234853larceny
larder73720973larder_
larders83516943larders
largely1136703largely
larger74417513larger_
larker104519243larker_
larkers113014513larkers
laser54633323la_ser_
lasers64925703la_sers
lashed105625213lashe_d
lashes94831003lashe_s
laster64830633laster_
lasters75627693lasters
latched133914063latche_d
latches123320123latche_s
latchet123117903latche_t
latchets133410013latchets
latchkey2042913latchkey
late47560483lat_e__
lated65240673lat_e_d
lateen64014863lat_een
lateens74210553lateens
laten54328343lat_e_n
latency1236033latency
latens64620213lat_ens
latent64124303lat_ent
laterad8310843lat_erad
lateral7313573lat_eral
latest63822703lat_est
latex124717113lat_e_x
lath76640383lath___
latherers12158853latherers
lathering13912253lathering
lathi85417203lath__i
lathiest11312653lathiest
lathing114315693lathing
lathis95516173lath_is
laths86022403lath__s
lathwork1845633lathwork
latke94817093latke__
latkes104715873latke_s
latte55426303latte__
latten65018203latte_n
lattens75014673lattens
lattes65324203latte_s
lauder73815013lauder_
lauders84012893lauders
laugher1136603laugher_
laughers1235923laughers
laundry1133513laundry
laveer94110423laveer_
laveers10329363laveers
laver85031793la_ver_
lavers94526363la_vers
lawyer12386973lawyer_
lawyerly1742143lawyerly
lawyers13377153lawyers
laxer125420333la_xer_
layer84626473la_yer_
layers93921183la_yers
lazier154214613lazier_
leacher124014843leacher_
leachers133712813leachers
leathered13148713leathered
lecher113415853lecher_
lechers123313963lechers
leery85919133l__eery
lethargy1542203lethargy
lethe85717303lethe__
lethean1037093lethean
lethes94818083lethe_s
letter63722583letter_
letters73819853letters
liter54736343lit_er_
liters65429883lit_ers
lithe84922013lithe__
lithest10513913lithest
lithify1644763lithify
litter64324853litter_
litters73422573litters
livery124910903l_ivery
loathe94211383loathe__
loathed11419443loathe_d
loathes103513243loathe_s
loathly1334713loath_ly
lotter64025603lotter_
lotters73921063lotters
lowery124112713l_owery
lusher93818763lusher_
lutherns1136293lutherns
luthier1038233luthier_
luthiers1135163luthiers
masher114123203masher_
mashers124621053mashers
mastery124214323mastery
matcher143214283matcher_
matchers153012433matchers
mater74438863mat_er_
maters85032393mat_ers
matey107022663mat_e_y
matier84321523matier_
matter84325343matter_
matters94421753matters
mither114218563mither_
mithers123516733mithers
mother113718643mother_
motherly16346093motherly
mothers123717623mothers
napery11489813na_pery
natter64420743natter_
natters73718063natters
neatherd12107193neatherd
nether94014163nether_
nitery94412173nit_ery
nother93815963nother_
oater55433733oat_er_
oaters65029793oat_ers
ochery14319443_ochery
other84219103_other_
others93918003_others
panther12611443panther_
panthers13510783panthers
papery134812743pa_pery
patcher143515143patcher_
patchers153413303patchers
pater74740723pat_er_
paters84935833pat_ers
pathway1844853pathway
patter84628263patter_
pattern93712053pattern
patters94825193patters
patzer173111643patzer_
patzers184210573patzers
plasher124215033plasher_
plashers133813453plashers
plastery13279703plastery
plater84427693plat_er_
platers93924093plat_ers
platier93716293platier_
platter93917413platter_
platters103415283platters
pleather1356653pleather_
pleathers1446453pleathers
pother113818853pother_
potherb14358683potherb
pothers123818623pothers
pottery123011073pottery
rasher95024123rasher_
rashers104020913rashers
rater54943283rat_er_
raters63936583rat_ers
rathe85821923rathe__
ratter64326313ratter_
ratters74422473ratters
satiety1038203satiety
slabbery15375773slabbery
slasher104515333slasher_
slashers113313613slashers
slater64429183slat_er_
slaters73123733slat_ers
slatey95417063slat_e_y
slathered13148543slathered
slatier74016813slatier_
slattern837093slattern
slavery13407893sla_very
slither104112983slither_
slithers114212953slithers
smithery16325703smithery
smothery16296063smothery
sphery14318883_sphery
swather134213603swather_
swathers144512083swathers
tannery10388663tannery
tater54138613tat_er_
taters64932203tat_ers
tatter64024573tatter_
tatters74520483tatters
tether93716103tether_
tethers103815313tethers
theory121098363__theory
there87527393__there
therm106018023__therm
thewy146311853__thewy
they107223753__the_y
tither94920283tither_
tithers104216733tithers
tother94117143tother_
tottery10388483tottery
tushery1335633tushery
wafery15398693wa_fery
waggery15276903waggery
washer124720393washer_
washers134517523washers
wastery134610993wastery
watchcry2142363watchcry
watcher153113403watcher_
watchers163511793watchers
water84733313wat_er_
waters95030633wat_ers
watter93221983watter_
wavery154610053wa_very
weather133513223weather_
weatherly1844403weatherly
weathers143412833weathers
wether123315393wether_
wethers135214693wethers
witchery19236093witchery
wither124321353wither_
withers134417753withers
wuther124511613wuther_
wuthers133711523wuthers
yatter94116213yatter_
yatters103914623yatters
zither183813083zither_
zithern19447023zithern
zithers193911973zithers

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.1561145455.1
2DLD Change Limit1340274467.04619021.7
3Display Results4464460.1562859.0
 (SQL Overall)1786914467.35824285.3
 
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.