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

411 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
iambus1046889(None) 
iambs95815051iamb_s
airbus848342airbus
ambos95321242_ambos
ambush1336102_ambush
amus65529612_am_us
babus95620332ba_bus
campus125213922campus
famous11412392famous
gambas115817512gambas
gambes116318312gambes
gambs105721122gamb_s
habus106317142ha_bus
iamb86623722iamb__
iambi95512192iamb_i
iambic12468252iambic
iambics13425622iambics
iambuses1235782iambuses
imbue939462i_mbue
imbues1037962i_mbues
jambes175914052jambes
jambs166014622jamb_s
kombus1435522kombus
lambs95921412lamb_s
limbus105710372limbus
mambas125716242mambas
mambos125414492mambos
nimbus10377272nimbus
ramous8417102ramous
ramus76418282ram_us
sambas104219262sambas
sambos104315192sambos
sambur10469502sambur
samburs11369342samburs
tabus74820922ta_bus
tambur10358712tambur
tamburs11288602tamburs
wammus13426732wammus
wampus13499012wampus
wamus105514682wam_us
abas68642083_a_bas
abbas95918643_abbas
abbes96723523_abbes
abos67734413_a_bos
abs59356073_a_b_s
abuse77119563_a_buse
abut66834953_a_but
abuts75417073_a_buts
abys97221883_a_bys
agamous1037923agamous
aimers84621913aimers
aimful1166703aimful
aims67738183aim__s
albas75925393_albas
albs68628573_alb_s
album92312653_album
albums10198273_albums
amahs107819063_amahs
amas67746293_am_as
amass77119683_amass
amber94523203_amber
ambers104519563_ambers
ambit94223693_ambit
ambits103713393_ambits
amble95924633_amble
ambles105121853_ambles
ambo88225133_amb_o
ambry123512093_ambry
amebas10311453_amebas
amens75624843_amens
amias75831463_amias
amicus10389993_amicus
amids85627503_amids
amies76837683_amies
amins75534313_amins
amirs75924913_amirs
amis66445313_am_is
amiss75823063_amiss
ammos94815823_ammos
amoks11413553_amoks
amour75014853_amour
amours83512643_amours
amps86230343_am_ps
ampul91110853_ampul
ampuls1098893_ampuls
amu58237323_am_u_
amuse75920833_am_use
amyls104512683_amyls
ankus91410683_ankus
anus47131113_a_nus
arbs66834733_arb_s
arcus76918863_arcus
argus66716543_argus
ascus75013583_ascus
awmous1157713awmous
babas96325733ba_bas
babes95834113ba_bes
babu85829223ba_bu_
babul96317713ba_bul
babuls105413643ba_buls
bamboo12310013bamboo
bamboos1348753bamboos
bams87044453bam__s
barbes104526233barbes
barbs95928193barb_s
barbut104617003barbut
barbuts11439843barbuts
bayous11411143bayous
bigamous1385493bigamous
bimbos124610513bimbos
biramous1266073biramous
bombes124916823bombes
bombs115818823bomb_s
bubus95115453_bubus
bus56950973___bus
cabs86739423ca_b_s
cactus104912233cactus
callus85317073callus
camas96333523cam_as
camass104114183camass
camber124418473camber
cambers134017433cambers
cambia124913143cambia
cambism1538023cambism
cambist13312103cambist
cambium1537313cambium
cambiums1644923cambiums
camels105217083camels
cameos105818003cameos
cames97047313cam_es
camos95927613cam_os
campos125217953campos
camps116330263cam_ps
cams87047283cam__s
cantus85117763cantus
carbos105122263carbos
carbs96031463carb_s
carpus105514303carpus
casus76419253ca_sus
caucus1039603caucus
combes125321733combes
combos125316613combos
combs116122963comb_s
combust1338353combust
comous10816503comous
crambes1339953crambes
crambos1336783crambos
cymous1388403cymous
dabs77139403da_b_s
damans94715983damans
damars93814993damars
dames85435853dam_es
damns84916923dam_ns
damps105220413dam_ps
dams77444373dam__s
darbs85323263darb_s
daubes94913703daubes
daubs85014563daub_s
diamins10312203diamins
dicambas1553793dicambas
digamous1296053digamous
dumbos114111083dumbos
dumbs105915753dumb_s
earbud936283earbud
earbuds1044633earbuds
emeus76913333_emeus
emus66821683_em_us
fabs98635863fa_b_s
fames105735923fam_es
famulus1235043famulus
favus114311733fa_vus
flambes14419503flambes
gabs76740423ga_b_s
gallus74313203gallus
gamas85431353gam_as
gamays126310903gamays
gamb96331843gamb__
gamba106018513gamb_a
gambe106219213gamb_e
gambia115912233gambia
gambias125010723gambias
gambir11509753gambir
gambirs12359073gambirs
gambit114714193gambit
gambits12399713gambits
gamble115417183gamble
gambles124016203gambles
gambol1138223gambol
gambols1238593gambols
gambusia1343573gambusia
gamers94420823gamers
games86238553gam_es
gamins94420043gamins
gammas115714693gammas
gamps105323713gam_ps
gams76648883gam__s
gamut8322983gam_ut
gamuts958783gamuts
garbs86321413garb_s
gombos114311093gombos
grampus12356313grampus
gumbos114610873gumbos
habu97325483ha_bu_
hagbush1642623hagbush
hagbut1278913hagbut
hagbuts1354923hagbuts
haikus13538293haikus
hakus125114113ha_kus
hamals114816813hamals
hamaul114210863hamaul
hamauls12387803hamauls
hamburg1544123hamburg
hamburgs1643463hamburgs
hames106138703ham_es
hams96446133ham__s
hamulus1235323hamulus
hamzas20119013hamzas
hiatus938223hia_tus
humbug1434803humbug
humbugs1534243humbugs
hummus1336243hummus
humus106215073hum_us
ibis66519563i__bis
ictus7249693i_ctus
iglus6609933i_glus
ileus54616893i_leus
images91411453images
imagos9117543imagos
imams91511103i_mams
imaum9139633i_maum
imaums10106293imaums
imbed105013633i_mbed
imbeds11456723i_mbeds
imbrue1035133i_mbrue
imbrues1135493i_mbrues
imbued1136153i_mbued
imids86015123i_mids
immies102412423immies
impis96213833i_mpis
imps86221113i_m_ps
incubus1144743incubus
incus73315053i_ncus
infamous1354533infamous
iodous7311493iodous
isbas71010393i_sbas
isms66213473ism__s
jabs135830093ja_b_s
jacobus1843173jacobus
jamb155523853jamb__
jambe165314753jamb_e
jambed184811403jambed
jams135231073jam__s
jumbos17379123jumbos
kabs107130843ka_b_s
kagus105812033ka_gus
kames115024693kam_es
kamiks11387913kamiks
kanzus1944603kanzus
kombu1347243kombu_
labs67145123la_b_s
lamas75532793lam_as
lamb86832143lamb__
lambast11129893lambast
lambda1146113lambda
lambdas1246243lambdas
lambed115614783lambed
lamber104418493lamber
lambers113817103lambers
lambie103213663lambie
lambies113015103lambies
lamby125114843lamb_y
lameds94812033lameds
lames75445543lam_es
lamias85020613lamias
lampas106615953lampas
lamps95624833lam_ps
lams66552263lam__s
lapsus8437273lapsus
limbas105313193limbas
limbos104712133limbos
limbs96118933limb_s
litmus836323litm_us
mabes96331533ma_bes
magus85318753ma_gus
mamas95930773mam_as
mamba116317513mamb_a
mambo115215733mamb_o
mamboes135011823mamboes
mameys13449523mameys
mamies104626243mamies
mamluk1434743mamluk
mamluks1543313mamluks
mammas94616403mammas
manus75924923ma_nus
maybes1339243maybes
maybush1742453maybush
miaous8511693mia_ous
minibus1136323minibus
momus96116113mom_us
mumus95517283mum_us
mus55946753__m_us
nabes75427093na_bes
nabis76020573na_bis
nabs66236193na_b_s
naevus934593naevus
nairus639143nairus
namers84517333namers
names74833363nam_es
numbs94913093numb_s
osmous8138183osmous
palpus104210283palpus
pampas124913993pampas
pams85641763pam__s
pappus9408373pappus
pareus85420743pareus
parous84024163parous
passus83610293passus
rabbis102613153rabbis
radius73914863radius
railbus934413railbus
rakus94413673ra_kus
rambla103510933rambla
ramblas112710263ramblas
ramble104519973ramble
rambles113118313rambles
ramees84620893ramees
ramets83517393ramets
ramies84630463ramies
ramps96224633ram_ps
rams65950773ram__s
rebus75721113_rebus
rhamnus1233133rhamnus
rhombus14243893rhombus
rimous8311913rimous
rubus76415053_rubus
rumbas102512013rumbas
rumpus10458893rumpus
sabes76437463sa_bes
sabs66643743sa_b_s
sacbut10811943sacbut
sacbuts1166473sacbuts
sadhus10298463sadhus
sagbut959753sagbut
sagbuts1065223sagbuts
sajous13310583sajous
samba95618773samb_a
sambal105215183sambal
sambals115213483sambals
sambar103914163sambar
sambars115113843sambars
sambhur1453083sambhur
sambhurs1543183sambhurs
sambo95118013samb_o
sambuca1344343sambuca
sambucas1444163sambucas
sambuke1544203sambuke
sambukes1644193sambukes
sameks12409323sameks
samps96124673sam_ps
samshus12125353samshus
shamus114112813sham_us
tabbis102910853tabbis
tabes76033923ta_bes
tabs66842983ta_b_s
tabu66328493ta_bu_
tabun75914373ta_bun
tabuns8489223ta_buns
talus55423263ta_lus
tamals84116623tamals
tambac122210243tambac
tambacs13219363tambacs
tambak14249263tambak
tambaks15218153tambaks
tambour1136343tambour
tambours1255863tambours
tambura11326463tambura
tamburas12316043tamburas
tamers84224033tamers
tames75242013tam_es
tamis76728723tam_is
tamps95524083tam_ps
tams67247933tam__s
tarbush1234173tarbush
tarsus6310513tarsus
taus46342733ta__us
taxus125512483ta_xus
tinamous1045953tinamous
tombs97818733tomb_s
umbos94613063_umbos
vagus96713813va_gus
valgus1047103valgus
vamps125415483vam_ps
varus85921183va_rus
vatus86114643va_tus
vaus75928923va__us
wabs97337233wa_b_s
walrus956433walrus
wamble134415753wamble
wambles143714023wambles
wambly16388663wambly
wames106432803wam_es
wampum15406053wampum
wampums16314213wampums
wombs125813343womb_s
yamens114010823yamens
yams95330733yam__s
yamun10419273yam_un
yamuns11336513yamuns
zamias174212923zamias
zebus164610053_zebus
zombis1936273zombis

Search took 7 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.1401276364.3
2DLD Change Limit1127164115.82619347.1
3Display Results4114110.1263261.9
 (SQL Overall)1786914116.09229332.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.