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

267 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
abmho123679(None) 
abmhos1334971abmhos
abhor10411062ab_hor
abo59045962ab__o
abohm1247972abohm
altho86312602altho
ambo88225142a_mbo
ammo85520132a_mmo
ancho104515302ancho
boho96923322_boho
mho86624622__mho
aah616252963a_ah_
aahs716428563a_ahs
ab410674763ab___
aba512850953ab__a
abaca95118043abaca
abaci94718843abaci
aback134816173aback
abaft10318063abaft
abaka114313823abaka
abamp11310603abamp
abamps1236253abamps
abas68642083ab_as
abase76023483abase
abash106016513abash
abate76627843abate
abator84512713abator
abaya104413173abaya
abba810522653ab_ba
abbas95918643abbas
abbe87627193ab_be
abbes96723523abbes
abbey125714933abbey
abbot9318453abbot
abeam9316533abeam
abed79734133ab_ed
abele76323253abele
abet610547943ab_et
abets75621673abets
abhors11410623ab_hors
abide86223713abide
able66340533ab_le
abled86926833abled
abler75624313abler
ables75935543ables
abloom1039783abloom
ably99725133ab_ly
abode85518813abode
abohms1335003abohms
aboil72217543aboil
aboma91114603aboma
abomas101113583abomas
aboon74918703aboon
abort76133583abort
abos67734413ab_os
about75229083about
above105414323above
abri65522213ab_ri
abris75722603abris
abs59356073ab__s
abuse77119563abuse
abut66834953ab_ut
abuts75417073abuts
abuzz15517213abuzz
aby810238063ab__y
abye97921003ab_ye
abyes105518533abyes
abys97221883ab_ys
abysm12598143abysm
abyss10669463abyss
ache96829823a_che
achoo10315083achoo
achy126316093a_chy
acme86924323acm_e
acmes96020653acmes
acmic11312333acmic
adman84517903adman
admen84516183admen
admit8319493admit
admix1557733admix
ado49146873a__do
adobo84711593adobo
aero45435343a_ero
aggro738013aggro
agha87417303a_gha
agio57828453a_gio
agma77623263agm_a
agmas85919873agmas
ago48845523a__go
ah513868793a__h_
aha611246643a__ha
ahchoo1445713ahchoo
ahi68040233a__hi
ahoy101919183a__hoy
ahs68644823a__hs
aim57858213aim__
aimed85626053aimed
aimer75926823aimer
aims67738183aim_s
akimbo1443393akimbo
alamo7418143alamo
albedo956123albedo
albino839933albino
alma66333023alm_a
almah106917253almah
almahs118611613almahs
almas76629773almas
alme65832163alm_e
almeh106214553almeh
almehs11619493almehs
almes75126543almes
alms65834923alm_s
almud84012183almud
almug8429303almug
aloha8513613aloha
alpha1049653alpha
also46423443a_lso
alto47831263a_lto
am411875563a_m__
ama510853303a_m_a
amah98927493a_mah
amahs107819063amahs
amas67746293a_mas
amber94523213amber
ambit94223713ambit
amble95924643amble
ambos95321253ambos
ambry123512103ambry
amen66733153a_men
ami56646813a_m_i
amia66836903a_mia
amid77036353a_mid
amido85720983amido
amie66339853a_mie
amigo86515473amigo
amin66042253a_min
amino75425503amino
amir65129753a_mir
amis66445323a_mis
ammino1069883ammino
ammono1047373ammono
ammos94815823ammos
amnio75218053amnio
amok10217403a_mok
amp77541023a_m_p
amps86230343a_mps
amu58237323a_m_u
amus65529613a_mus
amyl95515103a_myl
anchor113911973anchor
anchos114214893anchos
andro6314163andro
anglo65215373anglo
ankh111114413ankh_
ankhs12116723ankhs
anyhow1544103anyhow
apo511142123a__po
arch98628443arch_
archon11311753archon
arco68331543a_rco
arm58449623arm__
armed86324433armed
armer76924443armer
armet76739453armet
armhole1236943armhole
armor75118053armor
arms66137493arm_s
army96624183arm_y
arvo76023433a_rvo
ash67944603a_sh_
ashy107717353a_shy
atma68121773atm_a
atman75520143atman
atmas75721013atmas
audio62917103audio
aught95120703aught
author939763author
auto47432083a_uto
aviso85713963aviso
avo68936233a__vo
axman144813183axman
axmen145112273axmen
ayah108022993ayah_
ayahs116813523ayahs
azido155411543azido
azo128233393a__zo
baboo94319503baboo
bach116131393bach_
bah87755353_bah_
baht96740013_baht
bam78560143bam__
bamboo12310013bamboo
bams87044453bam_s
banco94019393banco
banjo143812443banjo
barhop13319643barhop
bash915240163bash_
basso76017283basso
bath95940083bath_
bathe105822883bathe
bathos116215633bathos
baths105922923baths
bazoo163815673bazoo
bimbo114811873bimbo
bio57846083_b_io
biro66131213_biro
bo410957573_b__o
bohos105618253_bohos
bolo65535953_bolo
boo58163663_b_oo
boyo96923843_boyo
bozo156821413_bozo
brio65432493_brio
bro56236603_b_ro
broo65129823_broo
bubo85621913_bubo
buhl95518223_buhl
buhr95315383_buhr
cabman123812503cabman
cabmen123610653cabmen
cameo95924993cameo
camo85731753cam_o
campo115219763campo
coho97524493_coho
combo114519433combo
compo115318573compo
daimio937463daimio
daimyo1233193daimyo
demo77427553dem_o
dumbo105614063dumbo
echo96615953_echo
gabbro11114953gabbro
gaucho1256223gaucho
gombo105814043gombo
gumbo104413583gumbo
ho510258273___ho
homo96126473hom_o
jumbo164311073jumbo
limbo95614813limbo
limo65529733lim_o
litho86513783litho
macho126120153macho
mambo115215743mambo
memo85924793mem_o
mhos95517773__mhos
mimeo96018683mimeo
mo49158483__m_o
moo58460513__moo
mucho125013443mucho
nacho105414383nacho
nympho1643583nympho
oho66534383__oho
ortho8312293ortho
pomo85828453pom_o
rabato83413263rabato
rancho114310853rancho
rho65924833__rho
romeo73719703romeo
sambo95118013sambo
schmo124510203schmo
shmo95318103shm_o
sumo67326313sum_o
taboo73418093tab_oo
tempo95214973tempo
tho67433963__tho
umbo85516663_umbo
who95526773__who

Search took 5 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 Filter178691836670.1231452772.4
2DLD Change Limit836672673.95321165.4
3Display Results2672670.0803337.5
 (SQL Overall)1786912674.15642995.9
 
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.