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

385 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
norther103973(None) 
northern1145581northern
northers1139331northers
nother93815961no_ther
another10289152ano_ther
bother115218062bo_ther
brother123311332brother
couther123914632couther
farther1348342farther
frother133110152frother
further1337002further
loather103711002loather
mother113718642mo_ther
mouther123812812mouther
murther1237952murther
narthex1734262narthex
neither1037572neither
nether94014162n_ether
north86018272north__
northerly1543522northerly
northerns1244932northerns
norths96812322north_s
nosher94616362no_sher
notcher123610932notcher
noter55025642no_t_er
other84219102_o_ther
porter84224412port_er
pother113818852po_ther
snorter74412662snort_er
soother104215042soother
sorter64425092sort_er
souther104116302souther
tother94117142to_ther
worthed1437872worthed
worthier1436712worthier
aborter939933abort_er
aether94213673_aether
airthed11328303airthed
anorthic1346973anorthic
anther93715063_anther
aortae65115473aortae_
archer115016243_archer
artier63419733_artier
barter85525373bart_er
bather115322513_bather
berthed13259123berthed
birthed13228593birthed
blather125314213blather
blether12459913blether
blither124812173blither
boater84622093boat_er
bolter83920753bolt_er
border94419973bor_der
borer75131273bor__er
bortzes1838223bortzes
botcher143613223botcher
bothers124317753bo_thers
bottler94211883bottler
brothel12318193brothel
brothers133410833brothers
burgher1337003burgher
burthen1236363burthen
carter84932273cart_er
chortler13336843chortler
cither114616683_cither
coacher143714123coacher
coater84329573coat_er
colter84625093colt_er
comether1537253comether
cooter85128613coot_er
copter109822013copt_er
corder94322883cor_der
corer75538873cor__er
corker124720853cor_ker
corkier133114303corkier
corner84625623cor_ner
cornier93017093cornier
coroner94218203coroner
cortex15311473cort_ex
coruler9311713coruler
cosher114819903co_sher
coster84331293cost_er
cotter84926673co_tter
cottier93814173cottier
coucher144515853coucher
cougher133711733cougher
courter94516483court_er
courtier1059333courtier
couter84930223cout_er
couthier13218913couthier
curter85320083curt_er
darter75320363dart_er
diether1147443diether
dirtier83312093dirtier
dither104417683_dither
dorkier122810023dorkier
dormer94415903dor_mer
dorper94314573dor_per
dorser74819183dor_ser
doter65428623do_t_er
dotier73917033do_tier
dotter74419343do_tter
dottier83910923dottier
earthed1139923earthed
earthen1039253earthen
earthier1137443earthier
either94517423_either
ether84518773__ether
father125116713_father
feather133613503feather
footer94320773foot_er
footier104115113footier
footler104011873footler
forager114412563forager
forayer13368953forayer
forcer114917343for_cer
forever1338953forever
forgather1643663forgather
forger104820773for_ger
forgoer1137693forgoer
forker134717903for_ker
forkier144311593forkier
former114221403for_mer
forte86131463fort_e_
fortes95327183fort_es
forth116222673forth__
forties104323863forties
foster94322223fost_er
frothed14288783frothed
frothers14279813frothers
frothier1435953frothier
furthers1436493furthers
garter74420513gart_er
gather104115863_gather
girthed12266243girthed
goatherd1335263goatherd
goiter74116203goit_er
gopher1239183go_pher
gorger86116983gor_ger
gorhen1038903gor_hen
gorier73719373gor_ier
gorsier83811073gorsier
goutier82612353goutier
harsher13310363harsher
heather133914853heather
hither124417253_hither
hooter94123933hoot_er
hootier104915353hootier
hornier103012463hornier
horsier103013243horsier
hostler103411023hostler
hotter94720083ho_tter
hurter93915853hurt_er
ingather1244783ingather
ither84617603__ither
jolter133513093jolt_er
joltier14318493joltier
josher164312963jo_sher
jostler14288223jostler
jotter134315633jo_tter
knotter11317643kno_tter
knottier12203983knottier
kosher134412973ko_sher
lather95124363_lather
leather103815783leather
lither94520953_lither
loathe94211383loathe_
loathed11419443loathed
loathers113310443loathers
loathes103513243loathes
lofter94614723loft_er
loftier1037763loftier
loiter64619173loit_er
looter64222323loot_er
lorimer937753lorimer
loriner7511893loriner
lotter64025603lo_tter
lurcher12338133lurcher
marcher143912973marcher
mither114218563_mither
molter84119423molt_er
moocher143610673moocher
mooter83921093moot_er
morphed1537133morphed
mortar83812043mort_ar
mortiser1078473mortiser
mosher114719793mo_sher
mothers123717623mo_thers
mothery153710513mo_thery
mothier121910213mo_thier
mottler94410343mottler
mouthed133811043mouthed
mouthers133811303mouthers
mouthier13208173mouthier
murthers1336543murthers
nastier74115293nastier
natter64420743n_atter
nattier73614623nattier
neater64424313neat_er
neatherd12107193neatherd
nerdier83110353nerdier
nervier10298833nervier
nester64124183nest_er
nestler73510453nestler
netter63722023n_etter
nettier74211813nettier
nettler7349503nettler
neuter63713793neut_er
niftier10328713niftier
nigher103612753n_igher
niter55028973n_it_er
nittier73512243nittier
nobbier11309163nobbier
nobbler113211183nobbler
nobler83713453no_bler
nodder84811943no_dder
noisier759453noisier
nonhero1057913no_nhero
nonuser7299143nonuser
nooser65517823no_oser
norite63221133norite_
norites74018803norites
normed95014543nor_med
northeast1266543northeast
northing12199063northing
northward1643253northward
northwest1544673northwest
noshed104413503no_shed
noshers103614333no_shers
noshes96618233no_shes
nosier63716323no_sier
notched134210303notched
notchers13279423notchers
notches123513653notches
note46239963no_t_e_
noted65123843no_t_ed
noters64021003no_t_ers
notes55034583no_t_es
noticer937273noticer
nourisher1274483nourisher
nowhere1337213no_where
nowhither1841963nowhither
nurser64314503nur_ser
nurture736643nurture
nurturer844473nurturer
nutter63918053n_utter
nuttier73112023nuttier
oater55433733_oat_er
ocher104516103_o_cher
ofter84116873_oft_er
orbier839993_orbier
order65019363_or_der
ormer75218373_or_mer
ortho8312293_orth_o
ostler63312193_ostler
others93918003_o_thers
otter54423973_o_tter
outer55633303_out_er
outhear10910603_outhear
oxter123414093_oxt_er
panther12611443panther
partier93520713partier
partner92811393partner
partyer12337873partyer
percher143313423percher
perter84422283pert_er
poacher143912323poacher
porches143815673porches
porker124917543por_ker
porkier133712343porkier
pornier93413133pornier
ported94223243port_ed
porters93722703port_ers
portiere1038773portiere
portlier1038373portlier
posher115018163po_sher
poster84129173post_er
potherb14358683po_therb
pothers123818623po_thers
potter83926983po_tter
pottier93516493pottier
potzer174411213po_tzer
pouter83923983pout_er
poutier93215323poutier
powter114116033powt_er
purtier93214093purtier
rather94319743_rather
rooter64926033root_er
rootier74915393rootier
roster64329083rost_er
rotter64325463ro_tter
rougher113511033rougher
router65025843rout_er
scorcher15196793scorcher
scouther1356943scouther
shorter103515503short_er
slather103816083slather
slither104112983slither
smoother13196673smoother
smother123510213smother
snootier8278383snootier
snorer64316763snor__er
snorted83813493snort_ed
snorters83410583snort_ers
snottier8217383snottier
snoutier8206973snoutier
softer94015313soft_er
soothe94214853soothe_
soothed113712743soothed
soothers113913433soothers
soothes103917113soothes
sootier73916613sootier
sorer56236593sor__er
sorner64720393sor_ner
sorrier72313733sorrier
sorted74523713sort_ed
sorters74221133sort_ers
sortie63621993sortie_
sortied83314103sortied
sorties74126403sorties
souter64225923sout_er
southed114313993southed
southern11438913southern
southers114214453southers
sporter93616553sport_er
sportier102010053sportier
swather134213603swather
swither133710993swither
tarter64023563tart_er
tartier74123263tartier
teether10349693teether
tether93716103_tether
thither13328103thither
tither94920283_tither
tocher114014913to_cher
together1243743together
tooter64420803toot_er
toothed113310243toothed
toothier1136423toothier
tootler73511123tootler
torched133511363torched
torchere1347683torchere
torches123715443torches
torchier1337463torchier
torquer16205323torquer
torte55431703tort_e_
torten65314353tort_en
tortes64826053tort_es
torture738593torture
torturer835493torturer
toter55932133to_t_er
totter65021463to_tter
toucher124814353toucher
tougher114210983tougher
touter63821033tout_er
trothed114010973trothed
trotter73312253trotter
turtler72610323turtler
untether1145163untether
unworthier16122483unworthier
vortex1635923vort_ex
voter85121053vo_t_er
voucher154110263voucher
wartier103413913wartier
weather133513223weather
wether123315393_wether
whether16346623whether
whither163510253whither
wither124321353_wither
wordier112511213wordier
worker134715113wor_ker
wormer114514913wor_mer
wormier12278763wormier
worrier102311683worrier
worser95117523wor_ser
worth117120523worth__
worthies14310283worthies
worths127812893worth_s
worthy15598803worth_y
writher134010853writher
wuther124511613_wuther
youthen1336153youthen
zither183813083_zither
zootier163611173zootier
zoster153715853zost_er

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 Filter1786911340270.420425454.8
2DLD Change Limit1340273857.25018486.5
3Display Results3853850.2661447.4
 (SQL Overall)1786913857.93622516.5
 
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.