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

262 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
ephahs143550(None) 
ephah1337061ephah_
ephas10311541epha_s
epha9310052epha__
ephods1238362ephods
ephors11311402ephors
epochs1335812epochs
hahs108333362__hahs
opahs105411982op_ahs
shahs115919512_shahs
aahs716428563__aahs
aghas97014873agha_s
ahs68644823___ahs
almahs118611613almahs
alphas1139513alpha_s
amahs107819063_amahs
aphids125110843aphids
aphis105917133aph_is
aphtha1444483aphtha
appals104812943appals
arhats9312973arhats
ayahs116813523_ayahs
bimahs13508303bimahs
blahs105616513_blahs
chads116122233_chads
chais107530313_chais
chams126028503_chams
chaos105622863_chaos
chaps125326063_chaps
chars105936643_chars
chats105730093_chats
chaws135022463_chaws
chays135319743_chays
coprahs14338153coprahs
dahs88231813__dahs
depths12428573dep_ths
dhaks13479703_dhaks
dhals95415443_dhals
ears46356593e__ars
earths95014593earths
eats47054873e__ats
echard1249223echard
echards1337963echards
eches106322163ech_es
echoes114715523echoes
echos105216463ech_os
eclats8313033eclats
edhs86212103e__dhs
egads74610923e_gads
eggars8398973eggars
eighths14388293eighths
elans55527753e_lans
embars103812883embars
embays131408333embays
emdash12244113emdash
emphases1568353emphases
emphasis15117673emphasis
encash11276943encash
endash10297123endash
enhalo987563enhalo
enhalos1087533enhalos
epact94921533ep_act
epacts105010393epacts
eparchs14196243eparchs
epees75219833ep_ees
ephebe1336063ephebe
ephebes1436153ephebes
ephebi1345083ephebi
ephebos1444113ephebos
ephebus1443283ephebus
ephod1139123eph_od
ephor10310013eph_or
ephori1139603ephori
epics95014283ep_ics
epinaos936283epinaos
epitaphs1543233epitaphs
epoch1248203epoch_
epodes94315563epodes
epos66723733ep__os
eposes84418783eposes
equals1538693equals
eras45441503e_ra_s
escars83913133escars
eschars1237183eschars
eskars10357593eskars
espials937093espials
essays965653essays
etas46432273e_ta_s
ethane94613243ethane
ethanes103713513ethanes
ethers94518413ethers
ethics11169283ethics
ethnos947053ethnos
ethos85514193eth_os
eths76619523e__ths
ethyls1235903ethyls
etnas54713933etna_s
exams14199083e_xams
exhale1636873exhale
exhales1737143exhales
exhaust1744243exhaust
expats1537683expats
eyas76427433e_ya_s
eyass84410783e_yass
eyras84715923eyra_s
fellahs13428393fellahs
galahs105512683galahs
gerahs1039413gerahs
ghats95818613_ghats
haes77651023__haes
hags86740843__hags
hah910655223__hah_
haha107821063__haha
hahas117118443__hahas
hams96446133__hams
haps96443463__haps
has67372653__ha_s
hash106936503__hash
hats76858253__hats
haws106439443__haws
hays106138073__hays
heehaws1643343heehaws
hehs106723963__hehs
hepcats1436473hepcats
heptads1335873heptads
horahs126313873horahs
huppahs1743333huppahs
jehads1735833jehads
jihads1734483jihads
jubhahs2242353jubhahs
keblahs1634563keblahs
keddahs1642923keddahs
khafs15648843_khafs
khans124615173_khans
khaphs18394323_khaphs
khats125316013_khats
lahars94013163lahars
lethals1038113lethals
lotahs9479873lotahs
mynahs14416443mynahs
nephews1533323nephews
obeahs1135863obeahs
odahs95610083_odahs
oghams1245853oghams
opah96218403op_ah_
opals75718353op_als
orphans1237773orphans
pacs85842183_p_acs
pads76742953_p_ads
pah88853593_p_ah_
pals66951353_p_als
pams85641763_p_ams
pans65855733_p_ans
paps86443453_p_aps
pars67560793_p_ars
pas58775743_p_a_s
pash95638133_p_ash
pass65239953_p_ass
paths105521383_paths
pats66460853_p_ats
paws96038183_p_aws
pays95940223_p_ays
peags86122843_peags
peaks114825623_peaks
peals75235493_peals
peans75437643_peans
pears75138613_pears
peas65755063_pea_s
peats76140193_peats
pecans101515833pecans
pechans14810503pechans
pechs125516203_pechs
pedals94316033pedals
pehs95625763_p_ehs
pekans121710553pekans
perhaps1446123perhaps
petals84719813petals
phage115113673_phage
phages125213513_phages
pharos11312063_pharos
phase104617213_phase
phases114618403_phases
phasis114614923_phasis
phat95837863_pha_t
phials1158873_phials
phis95724903_ph_is
phons105221143_phons
phots105418503_phots
phpht1538063_phpht
phuts104613503_phuts
pians75126963_pians
pias66542553_pia_s
piths105817543_piths
plans75731273_plans
plash104616563_plash
plats75531373_plats
plays106320773_plays
poohs103915713_poohs
prahu105013973_prahu
prahus11458243_prahus
prams96125513_prams
praos74923563_praos
prats76333393_prats
praus74621753_praus
prays105022433_prays
pshaws14435703pshaws
pujahs18404943pujahs
pyas96225703_pya_s
rajahs16497663rajahs
rayahs12579193rayahs
rehabs1139023rehabs
rehash1237433rehash
repass84114703rep_ass
repays113813973rep_ays
repeals94014523repeals
repeats94316053repeats
replans92814943replans
replays12399763replays
rupiahs1253333rupiahs
schavs1436493schavs
selahs9313213selahs
sepals85217373sep_als
sepias83616103sepia_s
shads95124483_shads
shags95123863_shags
shah105627783_shah_
shams105829413_shams
shaws116226263_shaws
shays116021433_shays
spaes76029973sp_aes
spahi10311143sp_ahi
spahis11310383spahis
spams94922193sp_ams
spans74528733sp_ans
spars75431543sp_ars
spas67036723sp_a_s
spats75031383sp_ats
spays105520513sp_ays
speaks125114583speaks
speans85417143speans
spears84019473spears
splash1168823splash
splats84817303splats
splays114910873splays
sprags95715823sprags
sprats85819933sprats
sprays115913643sprays
subahs114512383subahs
surahs94515543surahs
tepals85415043tep_als
tepas76521683tep_a_s
tephras1236283tephras
thaws116515463_thaws
torahs95115643torahs
unhats91110623unhats
upas68322383up_a_s
upheaps1494233upheaps
whams135515643_whams
whaps135115163_whaps
whats117718993_whats
yeahs115214553_yeahs
zephyrs2441943zephyrs

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.373479064.3
2DLD Change Limit1127162625.44020719.9
3Display Results2622620.0763447.4
 (SQL Overall)1786912625.88930343.2
 
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.