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

238 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
inarch113917(None) 
anarch11310391anarch
anarchs1237092anarchs
anarchy1544932anarchy
arch98628442__arch
endarch1345442endarch
eparch13258422eparch
exarch18196172exarch
inarched1486112inarched
inarches1358042inarches
inarm7314422inar_m
inarms8410092inarms
inch95420822in__ch
inearth1037042inearth
infarct1249012infarct
larch105919792_larch
march125622892_march
monarch1445952monarch
narc67127952_narc_
narco76718242_narco
narcs76122022_narcs
natch105018222_natch
parch125123002_parch
search113312422search
snatch114310602snatch
starch113013202starch
aargh96314083_aargh
anarchic1546853anarchic
arc510250903__arc_
arco68331543__arco
arcs67834783__arcs
autarch1246623autarch
bach116131393_ba_ch
barca91319433_barca
batch124620103_batch
beach124623893bea_ch
binary11312223binar_y
birch124914023_birch
blanch133410853blanch
brach126123303bra_ch
branch134014773branch
caroch13911763_caroch
catch125120373_catch
church1636483church
cinch124516243cin__ch
clach124617823cla_ch
coach125919453coa_ch
cranch133613533cranch
cratch134110793cratch
curch124415413_curch
dearth104212513dearth
diarchy1644673diarchy
dinar66319893dinar__
dinars75417563dinar_s
dyarchy1942503dyarchy
each95530583_ea_ch
earth85023053_earth
enact73525363ena_ct
endarchy1743343endarchy
enrich1138943enrich
eparchs14196243eparchs
eparchy17204753eparchy
ethnarch1642413ethnarch
exarchs19165193exarchs
exarchy22193693exarchy
farce104925323_farce
farci105919313_farci
farcy135217093_farcy
finance1238573finance
finch135416973fin__ch
garth94720223_garth
gnar56021383gnar__
gnarl65115573gnar_l
gnarls74210773gnarls
gnarly104610383gnarly
gnarr64810693gnar_r
gnarrs7407663gnarrs
gnars66718853gnar_s
gnash9449833gna_sh
gynarchy2042103gynarchy
harsh116418053_harsh
hatch135719593_hatch
hearth125315213hearth
hierarch1644043hierarch
hipparch2042833hipparch
ich86227743i___ch
imaret81121233imaret
inane52820343ina_ne
inaner62213543inaner
inanes62519803inanes
inapt73522693ina_pt
inarching1546343inarching
inarmed10268673inarmed
inbred93010403inbred
indict93115573indict
indri6310793indr_i
indris7311963indris
induce93811533induce
induct93212743induct
inearths1144933inearths
inert53234373iner_t
inerts64517023inerts
infancy1546173infancy
infarcts1345233infarcts
infare9313083infar_e
infares10313023infares
infect113413443infect
infra838643infr_a
infract12610003infract
inject153210233inject
inlace82513043inlace
inmesh1134863inmesh
innards837153innards
inro45920793in_r_o
inrun52911373in_run
inrush936513inrush
insect83916583insect
intact8314663intact
interarch1446713interarch
intrench1396593intrench
intro54915853intr_o
intron64215023intron
intros64215773intros
inure54119053inur_e
inured73114813inured
inures63318953inures
inurn53712863inur_n
inurns63310983inurns
invar839513invar__
invars9310003invar_s
inward10310333inwar_d
inwards1138343inwards
inwrap11115903inwrap
itch95619173i__tch
izar136616013izar__
izars145112933izar_s
kinara10310373kinar_a
kinaras1159123kinaras
klatch15445933klatch
knack104311043kna_ck
knar85818723knar__
knarry1334613knarry
knars94416113knar_s
laich105920713_laich
latch104620463_latch
leach105422523lea_ch
linac7315413lina_c_
linacs8310813lina_cs
loach105116363loa_ch
lurch104814633_lurch
mach116134473_ma_ch
marc87034623_marc_
marcs95726623_marcs
marsh105320853_marsh
match125621103_match
menarche1545813menarche
merch125417963_merch
mesarch1445533mesarch
minaret9520683minaret
minorca1145223minorca
monarchs1544833monarchs
monarchy1843603monarchy
nacho105414383_na_cho
nacre75715363_nacre
nah69847003_na__h
nance74721843_nance
nancy105214923_nancy
narcos86714203_narcos
nard56634453_nar_d
nards65928463_nards
nares55544153_nares
naric76824173_naric
naris55735293_naris
nark85230063_nar_k
narks96026033_narks
narky126017803_narky
nary76931223_nar_y
nautch1144813_nautch
nomarch1445353nomarch
north86018273_north
notch105613323_notch
oligarch1443083oligarch
omniarch1562723omniarch
orach105219233ora_ch
patch125221223_patch
peach125422493pea_ch
pentarch1544943pentarch
perch124518833_perch
pinch125619303pin__ch
planch133711443planch
poach124917863poa_ch
porch125918623_porch
quaich2047693quaich
ranch105019793_ranch
ratch104221363_ratch
reach105123883rea_ch
roach105717003roa_ch
sauch104918773_sauch
scarce104013633scarce
scarph13429603scarph
scorch13198093scorch
slatch114510533slatch
smirch1356463smirch
snack114718063sna_ck
snare54429983snar_e
snared74824553snared
snarer64620843snarer
snares65329033snares
snarf86525423snar_f
snarfs95113423snarfs
snark95419943snar_k
snarks104815733snarks
snarky134210843snarky
snarl54921083snar_l
snarls64016873snarls
snarly93815003snarly
snash84815673sna_sh
snatchy15355293snatchy
snath86419803sna_th
snitch11357943snitch
spinach1435403spina_ch
stanch113812373stanch
starchy15286743starchy
swarth126012083swarth
swatch14549283swatch
tach96132753_ta_ch
teach105221123tea_ch
thatch1435613thatch
torch107420933_torch
unarched14128553unarched
unarm7314453unar_m
unarms839243unarms
unary8315993unar_y
unearth1037063unearth
unlatch1245053unlatch
watch135617063_watch
winch135016663win__ch
xerarch1943843xerarch

Search took 6 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127162385.62620034.8
3Display Results2382380.0763131.6
 (SQL Overall)1786912385.82530676.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.