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

343 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
lanterns83830(None) 
lantern7310011lantern_
banters94623112banter_s
canteens1038572canteens
canters94827732canter_s
interns73116772_interns
lancers93616642lancer_s
landers84026212lander_s
lanners73618332lanner_s
lanthorns1246012lanthorns
lasters75627692laster_s
lateens74210552la_teens
latens64620212la_te_ns
lattens75014672latte_ns
lecterns1035942lecterns
linters73822632linter_s
pasterns104112622pasterns
patterns10439942patterns
planters102915322planter_s
ranters73323642ranter_s
salterns8388902salterns
santeras8311062santeras
santeros8311192santeros
slatterns935362slatterns
wanters104420092wanter_s
afters94717073_after_s
alters64924223_alter_s
angers75222543_anger_s
anteing8312813_anteing
antenna746383_antenna
antennas846403_antennas
antes56334323_ante__s
anthers103715203_anther_s
antlers74014743_antler_s
antres65021003_ant_res
astern64815813_astern_
asters65631603_aster_s
attorns738443_attorns
bacterins13410643bacterins
baiters94619303baiter_s
banders104324563bander_s
bangers104020353banger_s
bankers133919093banker_s
banners94018713banner_s
banteng1046363bante_ng
bantengs1134593bantengs
banter84825333banter__
bantered113313633bantered
banterer102811773banterer
banterers112410003banterers
bantering122414233bantering
barters94223033barter_s
basters94930303baster_s
battens95313263batte_ns
batters94626013batter_s
bitterns10428953bitterns
blasters104116143blaster_s
blatters104414093blatter_s
bunters94717123bunter_s
cancers114018583cancer_s
caners84629203can_er_s
cankers134418753canker_s
canners93822663canner_s
canoers94318373canoer_s
canteen9411083canteen_
canter85230113canter__
cantered113415983cantered
cantering122417373cantering
cantons95221203cant_ons
cantors94620753cantor_s
carters95327253carter_s
caserns94711223ca_serns
casters94729903caster_s
caterans10313223ca_terans
caters85336503ca_ter_s
caverns124510253ca_verns
centers94420603center_s
chanters134016743chanter_s
cisterns10369573cisterns
citterns10318123citterns
clangers114312343clanger_s
clatters103313913clatter_s
concerns122710833concerns
contemns1237403contemns
dancers103413093dancer_s
danders93921183dander_s
dangers94818213danger_s
darters84017603darter_s
daters74827373da_ter_s
daunters9329853daunter_s
eastern74412533eastern_
easters75125683easter_s
eaters65535953ea_ter_s
elaterins9410033ela_terins
elaters74420193ela_ter_s
enterons8314153_enterons
enters64425643_enter_s
externs1438233_externs
fainters11349693fainter_s
falters103916473falter_s
fanners103914653fanner_s
fastens105511753faste_ns
fattens105111713fatte_ns
flangers123311373flanger_s
flankers15349303flanker_s
flattens11357483flatte_ns
flatters113814203flatter_s
flaunters1234513flaunter_s
gaiters83516543gaiter_s
ganders93521703gander_s
gangers94418603ganger_s
garters84218233garter_s
gasters85624293gaster_s
gaters74728643ga_ter_s
gitterns9326573gitterns
glancers11408003glancer_s
glanders103811503glander_s
granters93614143granter_s
hafters134614333hafter_s
halteres113414593halteres
halters104619803halter_s
handers114224333hander_s
hangers113120813hanger_s
hankers144218133hanker_s
haptens124511343hapte_ns
hastens106214813haste_ns
haters94930403ha_ter_s
hatters104221523hatter_s
haunters11329543haunter_s
hinters103719583hinter_s
hunters103915733hunter_s
intern64016543_intern_
interne73218153_interne
internes82721233_internes
inters64328053_inter_s
inturns73210133_inturns
kantars11310033kantar_s
kanteles1238123kanteles
klaverns1532243kla_verns
laagers83411253laager_s
lacers85225253la_cer_s
lackers134120543lacker_s
lacteals1095663lacteals
lactean956473lactean_
lacteous1046773lacteous
ladders94115173ladder_s
ladens74516233la_de_ns
laders74927763la_der_s
ladlers84613573ladler_s
lagers74826143la_ger_s
laggers94216243lagger_s
lakers105225153la_ker_s
lambers113817113lamber_s
lamberts12348793lamberts
lamenters1137683lamenter_s
lampers113817333lamper_s
lamsters1099753lamster_s
lancer84319973lancer__
lances84824103lance__s
lancets93411163lance_ts
lanciers10308543lancier_s
lander74028483lander__
landlers94312833landler_s
lanes54946793lan_e__s
langrels9106173langrels
langurs889103langur_s
laniards967313laniards
lanker104123003lanker__
lanner64920603lanner__
lanneret82512363lanneret
lannerets9225483lannerets
lanolins8310533lanolins
lantana739603lant_ana
lantanas838263lantanas
lanthorn1147193lanthorn_
lanyards1266393lanyards
lappers113717463lapper_s
lapsers93911053lapser_s
larders83516943larder_s
larkers113014513larker_s
lasers64925703la_ser_s
lashers104121833lasher_s
lastborns1143383lastborns
laster64830633laster__
lateen64014863la_teen_
laten54328343la_te_n_
latent64124303la_te_nt
latents75214313la_tents
later54843923la_ter__
laterad8310843la_terad
lateral7313573la_teral
laterals8312753la_terals
latests73910313la_tests
latexes1438313la_texes
lathers104321883lather_s
latten65018203latte_n_
latter65027893latter__
latterly1136063latterly
lattes65324203latte__s
lattins74115483la_ttins
lauders84012893lauder_s
launders9358743launder_s
laveers10329363laveer_s
lavers94526363la_ver_s
lawyers13377153lawyer_s
layers93921183la_yer_s
leaners73718173lean_er_s
lectern937033lectern_
lenders84419643lender_s
lenten6312883lente_n_
letters73819853letter_s
levanters1254993levanter_s
lifters104313783lifter_s
lindens839413linde_ns
linens64818393lin_e_ns
liners65428853lin_er_s
lingers84223303linger_s
linkers114317713linker_s
lintels73311163linte_ls
linter64625343linter__
listens74014133liste_ns
listers74026533lister_s
liters65429883l_iter_s
litters73422573litter_s
loaners73913623loan_er_s
lofters103912903lofter_s
loiters74116613loiter_s
loners64225813lon_er_s
longerons1045893longerons
longers84819543longer_s
looters74419163looter_s
lotters73921063lotter_s
lucerns935753l_ucerns
lungers83817093lunger_s
lunkers113414603lunker_s
lusters73921443luster_s
luteins7310103l_uteins
lutherns1136293lutherns
mangers103521263manger_s
manners93417833manner_s
manteaus1036383manteaus
mantels94515043mante_ls
mantes84430783mante__s
mantras93815863mant_ras
martens93714953marte_ns
masters94628923master_s
maters85032393ma_ter_s
matters94421753matter_s
minters93822473minter_s
monteros1039453monteros
nankeens1243243nankeens
natters73718063natter_s
oaters65029793oa_ter_s
painters103013023painter_s
palters94021683palter_s
panders103423733pander_s
pangens103112063pange_ns
paniers94717333panier_s
panners93621273panner_s
pantheons1446513pantheons
panthers13510783panther_s
panzers184012013panzer_s
pastern94415063pastern_
pasters94531733paster_s
patens84820863pa_te_ns
paters84935833pa_ter_s
pattens95414923patte_ns
pattern93712053pattern_
patters94825193patter_s
plaiters103512633plaiter_s
planers94517943plan_er_s
plankters1544583plankter_s
planners10399933planner_s
plantains1147493plantains
planter94017803planter__
plasters103518133plaster_s
platens94213983pla_te_ns
platers93924093pla_ter_s
platters103415283platter_s
posterns102713723posterns
punters93617043punter_s
quarterns18285153quarterns
rafters103715633rafter_s
rangers83621043ranger_s
rankers113217463ranker_s
ranter63826823ranter__
rasters74629023raster_s
raters63936583ra_ter_s
ratteens8256053ratteens
rattens74213403ratte_ns
ratters74422473ratter_s
renters74224813renter_s
saltern74010653saltern_
salters73622253salter_s
sanders84025943sander_s
sangers84421943sanger_s
santera7311303santer_a
santeria8311653santeria
santerias9311843santerias
santero7311133santer_o
santirs7312963santir_s
santurs7310763santur_s
sateens73710753sa_teens
saunters82911753saunter_s
sauterne846253sauterne
sauternes947023sauternes
sinters74024083sinter_s
slanders94014013slander_s
slaters73123733sla_ter_s
slattern837093slattern_
sterns64616763__sterns
tankers113416913tanker_s
tanners74018393tanner_s
tantaras8269543tantaras
tantras73112093tant_ras
tasters74225643taster_s
taters64932203ta_ter_s
tatters74520483tatter_s
taunters8259273taunter_s
tautens7317843taute_ns
taverns10317803ta_verns
tenters73921103tenter_s
terns55226873___terns
tinters74221113tinter_s
vanners103612843vanner_s
vaunters11327753vaunter_s
venters103717733venter_s
wafters134112813wafter_s
waiters104218623waiter_s
wanders114221333wander_s
wankers144514713wanker_s
wanter94423053wanter__
wantons103713013want_ons
wasters104026593waster_s
waters95030633wa_ter_s
westerns11328963westerns
winters103720483winter_s
xanthans1845693xanthans
xantheins1944813xantheins
xanthins1846943xanthins
yantras10259003yant_ras
yatters103914623yatter_s
zanders173015793zander_s

Search took 9 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.420425454.8
2DLD Change Limit1461623437.59319249.6
3Display Results3433430.1402450.0
 (SQL Overall)1786913438.15321917.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.