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

170 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
ephori113960(None) 
ephor10310011ephor_
ephors11311401ephors
ephebi1345082ephebi
ephod1139122epho_d
ephods1238362ephods
ephoral1248402ephoral
euphoria13116862euphoria
euphoric15107042euphoric
exhort16410802exhort
poori74816232_poori
abhor10411063abhor_
abhors11410623abhors
alphorn1246393alphorn
amphora1446923amphora
aphonia122711883aphonia
aphonic142713393aphonic
aphorise1339983aphorise
aphorism1548643aphorism
aphorist13412503aphorist
aphorize2249043aphorize
aphotic142913113aphotic
aporia8315863ap_oria
aport75432173ap_ort
ashore9414613ashore
bethorn1238643bethorn
choir105313593_choir
chord115917263_chord
chore105126763_chore
choric133515893_choric
cohort1110720263cohort
dehorn10439653dehorn
dehort104618103dehort
deplore1039483deplore
deport94922393dep_ort
dhobi1136963_dhobi
dhoti9310103_dhoti
echard1249223echard
echini114710433echini
echo96615953echo__
echoed125211153echoed
echoer114011103echoer
echoers12459683echoers
echoes114715523echoes
echoey14397853echoey
echoic1339043echoic
echos105216463echo_s
effort1238623effort
elhi7612403elh__i
emboli1037473emboli
emporia1148753emporia
enchoric1547103enchoric
encore8314773encore
enoki9268873e_noki
enorm74415633e_norm
envoi878023envo_i
epeiric1145313epeiric
epha9310053eph__a
ephah1337063eph_ah
ephahs1435503ephahs
ephas10311543eph_as
ephebe1336063ephebe
ephebic1646513ephebic
epheboi1442983epheboi
ephedra1344213ephedra
ephedrin1444703ephedrin
ephorate1359503ephorate
epigoni1056093epigoni
epoch1248203ep_och
epode85114093ep_ode
epos66723733ep_o_s
epoxy17465773ep_oxy
error53712233error_
errors63311313errors
escort84616483escort
ether84518773ether_
etheric12311783etheric
ethers94518413ethers
ethos85514193etho_s
ethoxy1933923ethoxy
euphonic15117813euphonic
euphony1545403euphony
euphorbia16122523euphorbia
euphorias1466283euphorias
euphotic15117523euphotic
euphroe1245393euphroe
exhorts1746313exhorts
explore1646613explore
export15412183export
extort13513973extort
hora76136553__hora
horn76735613__horn
houri85915233__houri
ichor1039473ichor_
ichors11310413ichors
leghorn1146223leghorn
leporid1048153lep_orid
nephric1446213neph_ric
nephron1246653nephron
nori47133143__nori
padri85815163_padri
peloria9310953peloria
peloric11310713peloric
peri65636973_p_eri
phi86524203_ph__i
phobia13278593_phobia
phobic153010063_phobic
phon95925383_pho_n
phone105621933_phone
phonic133315203_phonic
phono104917023_phono
phons105221143_phons
phony136715443_phony
phot95534353_pho_t
photic133316423_photic
photo104417223_photo
phots105418493_phots
poi57244663_p_o_i
poor65630223_poor_
pooris83916843_pooris
pore66451263_p_ore
pork106929683_p_ork
porn65636023_p_orn
port66059633_p_ort
psoai7469923_psoai
puri65931443_p_uri
pylori1147163pylori
report85326013rep_ort
satori6415833satori
schorl1179803schorl
senhor93010803senhor_
senhora10348663senhora
senhors103512123senhors
shogi95013993_shogi
shoji15419943_shoji
shore85432643_shore
shorl84720243_shorl
shorn85722173_shorn
short85040523_short
shri76021693_sh_ri
sori46039833__sori
sphere113313653sphere
spheric14510073spheric
sphery14318883sphery
splore81611303splore
spoor75016353spoor_
spoors84014023spoors
spore75428593sp_ore
sport75935983sp_ort
tephra1136483teph_ra
thoria93012883_thoria
thoric114314033_thoric
thorn85318703_thorn
thoro86217873_thoro
thorp104414263_thorp
tori47542153__tori
upbore10247883upbore
uphoard1344573uphoard
uphold12126903uphold
uphove1436133uphove
uphroe1136083uphroe
uptore8279453uptore
uptorn8268093uptorn
whore116018043_whore
whorl114612453_whorl
whort114623693_whort
zephyr2342083zephyr_
zephyrs2441943zephyrs
zeppoli2042133zeppoli
zori137722923__zori

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 Limit1127161706.51617298.3
3Display Results1701700.0463695.7
 (SQL Overall)1786911706.70226662.3
 
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.