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

201 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
phobia1327860(None) 
phobias14228181phobias
phobic153010071phobic
aphonia122711882aphonia
cobia94117512_cobia
dhobi1136972dhobi_
dhobis1236112dhobis
obia67923112__obia
phobics16286702phobics
phonic133315212phonic
photic133316442photic
podia8415282p_odia
probit103218352probit
thoria93012892thoria
acholia1239973acholia
aerobia939463aerobia
alodia71112453alodia
amphibia1744403amphibia
anopia83412393anopia
anoxia133510023anoxia
aphagia13247663aphagia
aphasia122510873aphasia
aphelia1249423aphelia
aphonias132611143aphonias
aphonic142713393aphonic
aphotic142913123aphotic
aporia8315863aporia
atonia63816513atonia
boobie104015293boobie
cambia124913153cambia
chia96026623ch__ia
choana1138443choana
choir105313603cho_ir
chola104718033cho_la
cholla113911023cholla
chopin132712193chopin
chorea115216093chorea
chorial124214143chorial
choric133515903choric
cobias104014993_cobias
cobra95214403_cobra
coria75828323_coria
cumbia12379893cumbia
dhoora1035653dhoora
dhoti9310123dhoti_
dhotis1038973dhotis
dobie84920333_dobie
dobla84913643_dobla
dobra85013103_dobra
doobie94712683doobie
ephebi1345083ephebi_
ephebic1646513ephebic
ephori1139603ephori_
euphorbia16122523euphorbia
euphoria13116863euphoria
folia83618933_folia
gambia115912253gambia
globin9309723globin
gloria71910553gloria
gonia64117533_gonia
habit103027023_habit
hob87550923_hob__
hobbit132810543_hobbit
hobby155913733_hobby
hobo97026083_hob_o
hobos106321353_hobos
hobs97038983_hob_s
holla84918493_holla
homie104622533_homie
honda9414983_honda
hooka125513903_hooka
hora76136563_ho_ra
hosta85917833_hosta
hoya107418373_ho_ya
labia75219013_labia
logia68116603_logia
mahonia1238443mahonia
myopia13318443myopia
niobic1037243niobic
noria55722183_noria
nubia7311233_nubia
oba57531553__ob_a
obi57127733__obi_
obias76116863__obias
obis66226843__obis
obit66837083__obit
ohia75719363__ohia
pallia83015593pallia
peloria9310953peloria
pembina1345223pembina
pennia84412973pennia
pereia85217983pereia
phasic133612053phasic
phasis114614923phasis
phatic133014413phatic
phelonia1347043phelonia
phenix1837133phenix
phi86524203ph__i_
phial10313203ph__ial
phis95724903ph__is
phiz186718843ph__iz
phocine1438833phocine
phoebe1335003phoebe
phoebes1435813phoebes
phoebus1443823phoebus
phoenix1944363phoenix
phon95925383pho__n
phonal11310383phonal
phone105621933pho_ne
phoned124014553phoned
phones114121213phones
phoney143612983phoney
phonics143110723phonics
phonied133710563phonied
phonier122710633phonier
phonies123717513phonies
phonily1537103phonily
phoning13312053phoning
phono104917023pho_no
phonon114012033phonon
phonos114114793phonos
phons105221143pho_ns
phony136715443pho_ny
phooey14379233phooey
phot95534363pho__t
photics142810483photics
photo104417233pho_to
photog12379813photog
photon1111514833photon
photopia1549733photopia
photos113316643photos
phots105418503pho_ts
phyla13469183ph_yla
phylic16279553phylic
physic16288473physic
physis14359663physis
phytin14459013phytin
pia56848033p___ia
pionic103515953pionic
poboy121612223p_oboy
pogonia1048933pogonia
poi57244663p_o_i_
pois66539043p_o_is
polio75722553p_olio
polis74731163p_olis
polka11310413p_olka
poori74816233poori_
pooris83916843pooris
poppa8409893p_oppa
posit75833333p_osit
prebid113512843prebid
proa66229963pro__a
probe94320813prob_e
probed114114823probed
prober104516073prober
probes104119453probes
probing123314443probing
probits112712573probits
probity14299683probity
profit113016273profit
prolix1538683prolix
propria1149933propria
prosit85124593prosit
protea82214763protea
psoai7469923psoai_
psocid1137253psocid
ptosis83611823ptosis
ptotic102713373ptotic
pubic114513723p_ubic
pubis94616473p_ubis
pyemia1337553pyemia
pyoid11513763pyo_id
pyosis114012123pyosis
pyuria1136953pyuria
rhizobia2251883rhizobia
rhodic12227233rhodic
rhombi13365203rhombi_
rhombic16264533rhombic
rhotic112711233rhotic
robin74820283_robin
scholia1237833scholia
scoria8513503scoria
scotia8310803scotia
sharia93116733sharia
shogi95014013shogi_
shogis103810943shogis
shoji15419963shoji_
shojis16348493shojis
shortia1048193shortia
showbiz2453223showbiz
soba64927923_sob_a
terbia8311153terbia
thorias102312053thorias
thoric114314043thoric
thulia936113thulia
tibia7312403_tibia
urbia7311143_urbia
utopia8107883utopia
whoa106615203who__a
whosis1237173whosis
zoophobia2554003zoophobia

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 Limit1127162015.11022057.9
3Display Results2012010.0633190.5
 (SQL Overall)1786912015.54632219.8
 
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.