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

479 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
ihrams113717(None) 
ihram10310181ihram_
ashrams1236652ashrams
chams126028502ch_ams
charms135218842charms
crams96229152_crams
dirams94413702dirams
dirhams13376312dirhams
drams86025832_drams
forams115115912forams
grams85327312_grams
hams96446132_h_ams
harms106829012_harms
imams91511112i_mams
inarms8410092inarms
jorams154810532jorams
mihrabs1444202mihrabs
prams96125512_prams
rams65950772__rams
scrams105216622scrams
shams105829412sh_ams
tharms115712242tharms
thirams1236822thirams
thraws129211102thraws
thrums11429122thrums
trams75327672_trams
whams135515642wh_ams
zirams17438642zirams
alarms85913053alarms
araks94820883_araks
arame75026623_arame
arames84622573_arames
arhats9312973arhats
arms66137493_ar_ms
arras55626133arra_s
arrays95311683arrays
arums75517833_arums
ashram1139053ashram_
asrama839193asrama
asramas938303asramas
auras55932563aura_s
aurums849383aurums
bams87044453__bams
barms96128463bar_ms
beams95328173_beams
berms95323663ber_ms
bharals1236733bharals
blams95023853_blams
borals86721913borals
boras75938303bora_s
brads85528293_brads
braes75735053_braes
brags85625103_brags
brans75437433_brans
bras65746453_bra_s
brass75428023_brass
brats75336013_brats
braws106425193_braws
brays106723113_brays
breams104815043breams
brims94721623_brims
burans85019303burans
buras74736303bura_s
cams87047283__cams
carats85929023carats
caroms105619573caroms
chads116122233ch_ads
chais107530313ch_ais
cham115532313ch_am_
champ145017963ch_amp
champs154915683ch_amps
chaos105622863ch_aos
chaps125326063ch_aps
charas114223613charas
chards125119733chards
chares115631803chares
charks155219703charks
charm126124663charm_
charrs115219193charrs
chars105936643ch_ars
charts115823093charts
chasm125518793ch_asm
chasms135513143chasms
chats105730093ch_ats
chaws135022463ch_aws
chays135319743ch_ays
cheaps134613683cheaps
cheats114519543cheats
chias104625523chia_s
chiasm13449103chiasm
chiasms14357523chiasms
chiaus113611313chiaus
chirms135113983chirms
chlamys1733783chlamys
chorals124614113chorals
chrism13710673chrism
chrisms1499143chrisms
chroma132912473chroma
chromas142512693chromas
chrome133214813chrome
chromes142914933chromes
chromo132811013chromo
chromos142610273chromos
chromy16309903chromy
chums125015833ch_ums
citrals91111673citrals
clams95127673_clams
corals85325143corals
corms95626223cor_ms
crabs95421393_crabs
crags85622573_crags
cram85635493_cram_
cramp115120693_cramp
cramps125615563_cramps
craps95328643_craps
crass76328043_crass
craws105723123_craws
creams104715253creams
dams77444373__dams
derats74625063derats
derays105514253derays
dermas94116813dermas
derms85022893der_ms
dhaks13479703dh_aks
dhals95415443dh_als
dharma1276103dharma
dharmas1356513dharmas
diagrams1246133diagrams
diorama1046533diorama
dioramas1145513dioramas
diram84419473diram_
dirham12378273dirham_
disarms1039043disarms
dishrags1346203dishrags
dorms85723843dor_ms
drabs85119673_drabs
drags75521113_drags
dram75832003_dram_
drama85117423_drama
dramas95814663_dramas
drats66628373_drats
draws95119373_draws
drays95819773_drays
dreams94513983dreams
drums85415873_drums
dunams937833dunams
duras65727733dura_s
durums948153durums
engrams1038073engrams
epigrams1346113epigrams
eras45441503_era_s
exams14199083_exams
eyras84715923eyra_s
farads104713273farads
farms106324953far_ms
ferals94216643ferals
ferbams1435743ferbams
firms105217423fir_ms
flams105125013_flams
fleams115011943fleams
foams105017953_foams
foram105124933foram_
forays124813003forays
forms105327053for_ms
forums114611843forums
frags96322173_frags
frame105821803_frame
frames115119863_frames
fraps105620553_fraps
frass85321123_frass
frats86829673_frats
frays116920103_frays
furans94515953furans
gams76648883__gams
gerahs1039413gerahs
germs85118873ger_ms
ghats95818613gh_ats
glams85822933_glams
gleams94812253gleams
gloams95210663gloams
gorals76917653gorals
gorms85619593gor_ms
grabs85719693_grabs
grads75625753_grads
gram77034583_gram_
grama85620283_grama
gramas94317203_gramas
gramp106218323_gramp
gramps114114273_gramps
grans64832543_grans
grass66125203_grass
grays95621333_grays
haafs115711163_haafs
haars85620473_haars
haems105517013_haems
haes77651023_h_aes
hags86740843_h_ags
hahs108333363_h_ahs
halms105225213_halms
ham86363283_h_am_
hame97043133_h_ame
hames106138703_h_ames
haps96443463_h_aps
harass9313943harass
hards96435653_hards
harems115513823harems
hares86255543_hares
harks126333433_harks
harls85634503_harls
harm95637793_harm_
harps105926873_harps
harts88441593_harts
has67372653_h_a_s
hats76858253_h_ats
haws106439443_h_aws
hays106138073_h_ays
heads95127113_heads
heals85733463_heals
heaps105223223_heaps
hears86737373_hears
heats85838403_heats
helms105619463_helms
hems95534943_h_ems
herms105626433_herms
hijabs1833083hijabs
hijrahs2043443hijrahs
hijras1635773hijra_s
hims95230983_h_ims
hirees95117293hirees
hirers94518063hirers
hires86134343hir_es
hoars85925553_hoars
holms105117803_holms
horahs126313873horahs
horas86333103hora_s
hums96831423_h_ums
iamb86623733i__amb
iambs95815063i__ambs
ideals75012503ideals
ideas65919013idea_s
idioms956413idioms
ikats95311153i_kats
iliads7448673iliads
imam81718333i_mam_
imaums10106303imaums
imbalms1334553imbalms
inarm7314423inarm_
infamy1435653infamy
inlays9389873inlays
inroads837043inroads
inruns6359513inruns
inseams9307903inseams
inthrals11258503inthrals
invars9310003invars
inwraps12105253inwraps
iotas54821113iota_s
irade65618153i_rade
irades74517393i_rades
irate55627983i_rate
ires45639283i_r_es
irids66417783i_rids
iris45732553i_r_is
irks86220133i_r_ks
irons55324133i_rons
isbas71010403isba_s
isms66213473i__sms
isograms1146473isograms
items7499613i_tems
ixias12488373ixia_s
ixoras1337193ixora_s
izars145112933i_zars
jams135231073__jams
jihads1734483jih_ads
jimjams1742073jimjams
joram145816983joram_
jorums15408093jorums
jurats134213203jurats
kalams12310603kalams
karats106420493karats
karmas123013753karmas
khafs15648843kh_afs
khans124615173kh_ans
khats125316013kh_ats
khoums1594013khoums
koras95927113kora_s
korats105416063korats
kormas124511243kormas
lams66552263__lams
larums83610533larums
libras83711703libra_s
lingams104510193lingams
liras56021983lira_s
loams75619863_loams
lorans65117603lorans
madams11310943madams
maras75443293mara_s
marrams11310123marrams
mihrab1335523mihra_b
morals85324643morals
moras76438783mora_s
morass84614503morass
morays114613883morays
murals84016763murals
muras75329583mura_s
nizams1735413nizams
norms76019313nor_ms
ogams84112683_ogams
oghams1245853oghams
ohias84415573ohia_s
ohms95514033oh__ms
okras94410973okra_s
orals55826483_orals
pams85641763__pams
paramo102614643paramo
paramos113213513paramos
paras76143043para_s
perms95524513per_ms
pharos11312063pharos
phials1158873phials
phrase11109903phrase
phrases12711463phrases
phreaks1634543phreaks
praams10459643praams
pram85733493_pram_
praos74923563_praos
prats76333393_prats
praus74621753_praus
prays105022433_prays
prims95425933_prims
proms95426413_proms
pyrans11411063pyrans
rads56046613__rads
rags55448373__rags
rais45252623__rais
ram56867273__ram_
rami66034093__rami
ramp85934003__ramp
ramps96224633__ramps
ramus76418283__ramus
raps66247733__raps
ras37575393__ra_s
rats46260373__rats
raws75238213__raws
rays77642353__rays
reams75729623_reams
rearms85114653rearms
rems66237723__rems
rheas84816953rhea_s
rheums1135463rheums
ricracs1136363ricracs
rims65936313__rims
ripraps1134943ripraps
roams74919613_roams
roms67038963__roms
rums64833473__rums
sarans64224433sarans
scams94423973_scams
scrags95713803scrags
scram910621623scram_
scraps106017243scraps
screams114810623screams
scrims104615933scrims
scrums104614253scrums
seams75731663_seams
seracs84418573seracs
serais64326133serais
serums83916303serums
shads95124483sh_ads
shags95123863sh_ags
shahs115919513sh_ahs
sham96436363sh_am_
shamas113717943sh_amas
shame105726703sh_ame
shames114726223sh_ames
shamos114216983sh_amos
shamus114112813sh_amus
shards104319173shards
shares95236413shares
sharks135019723sharks
sharns95516983sharns
sharps115516083sharps
shawms14579563shawms
shaws116226263sh_aws
shays116021433sh_ays
sheafs124912883sheafs
sheals94420643sheals
shears93820903shears
sheas86331793shea_s
shims104422553sh_ims
shnaps1148083shnaps
shoals94215793shoals
shoats94117083shoats
shorans102812413shorans
shrank13359123shrank
shreds105613053shreds
shrews129313923shrews
shrimp13478773shrimp
shrimps14516753shrimps
shris84221453shr_is
shrubs11409213shrubs
shrugs10469163shrugs
shwas116415103shwa_s
sirrahs10377303sirrahs
sirras63814863sirra_s
slams74927903_slams
smarms105712533smarms
soras55041013sora_s
spams94922193_spams
sprags95715823sprags
sprats85819933sprats
sprays115913643sprays
steams84916903steams
straps87721783straps
strass67117223strass
straws98718673straws
strays96417933strays
streams94713373streams
strums84716453strums
surahs94515543surahs
suras55336333sura_s
swarms116112173swarms
tams67247933__tams
tarama8412733tarama
taramas9612703taramas
teams75726513_teams
terais64023513terais
terms75523473ter_ms
tharm105916643tharm_
thaws116515463th_aws
therms115914873therms
thiram1139963thiram_
thrall93810293thrall
thralls10299043thralls
thrash12258363thrash
thrave126010273thrave
thraves13469713thraves
thraw1110515923thra_w
thrawn12769423thrawn
threads11419953threads
threaps12488643threaps
threats104311673threats
threes97117323threes
thrips11299013thrips
throats104612193throats
throbs118311373throbs
throes97518673throes
throws129715233throws
thrum104713633thrum_
tiaras6314553tiara_s
torahs95115643torahs
toras55540373tora_s
tram67034553_tram_
tramp96319773_tramp
tramps105114453_tramps
trans54933043_trans
traps75727483_traps
trass56226473_trass
trays85623433_trays
trigrams11116353trigrams
trims75021473_trims
uhlans937573uhlans
unarms839243unarms
unjams1555703unjams
varas86028193vara_s
warms107726853war_ms
wham125321693wh_am_
whamo135511263wh_amo
whaps135115163wh_aps
wharfs1546373wharfs
whats117718993wh_ats
wheals124512523wheals
wheats125013223wheats
whelms14377573whelms
whims134515333wh_ims
wigwams1643883wigwams
worms105320763wor_ms
wraps105617153_wraps
yams95330733__yams
ziram163912893ziram_

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.406440125.6
2DLD Change Limit1127164795.73619650.6
3Display Results4794790.1533130.7
 (SQL Overall)1786914796.29528386.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.