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

204 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
phoebe133500(None) 
phoebes1435811phoebes
ephebe1336062eph_ebe
hebe96424702_h_ebe
phoebus1443822phoebus
phone105621932pho_ne
phoneme1446202phoneme
plebe95014872p_lebe
probe94320812pro_be
thebe107515432th_ebe
adobe84814713ado_be
ahorse9311513ahorse
amoeba1035603amoeba
amoebae1145533amoebae
bombe115519313_bombe
chebec1536963ch_ebec
cheese113812763cheese
choice132010523choice
choke145118023cho_ke
choose115116143choose
chore105126763cho_re
chose105925403cho_se
chouse116017563chouse
chowse144711753chowse
cohere112716993cohere
combe116223543_combe
cooee74531023cooe_e
coombe124110093coombe
dhobi1136973dho_bi
dhole95215363dho_le
ephebes1436153eph_ebes
ephebi1345083eph_ebi
ghee85726113gh_e_e
glebe85016443_glebe
globe84917013glo_be
grebe85114943_grebe
hebes105521673_h_ebes
heeze175313483_heeze
heme95034413_h_eme
here76447103_h_ere
hob87550923_ho_b_
hobbed144114303_hobbed
hobber134114633_hobber
hobble133913433_hobble
hobby155913733_hobby
hobo97026083_ho_bo
hobs97038983_ho_bs
hoe67562723_ho__e
hoed87837983_hoe_d
hoer76533983_hoe_r
hoers85724923_hoers
hoes75755733_hoe_s
hoise85224773_hoise
hoke115935933_ho_ke
hole77553393_ho_le
hombre13309303_hombre
home98042443_ho_me
homie104622533_homie
hone77549323_ho_ne
hope96639673_ho_pe
horde94623053_horde
horse86132653_horse
hose76547243_ho_se
hotbed123310683_hotbed
house89131423_house
hove107132223_ho_ve
howe106734103_ho_we
hoyle11314413_hoyle
lobe65535363_lo_be
obe56638643__o_be
pahoehoe1642063pahoehoe
paleae84820293paleae
pareve114613013pareve
payee105524723paye_e
pee56066513p__e_e
peeve104915253p_eeve
peke105926203p__eke
pele65539553p__ele
people10310193people
pere66450263p__ere
pewee10319973pewe_e
phage115113673ph_age
phase104617213ph_ase
phew128417113ph_e_w
phlegm1433093phlegm
phloem1335713phloe_m
phloems1433523phloems
phobia13278603phobia
phobic153010073phobic
phocine1438833phocine
phoebuses1643213phoebuses
phoenix1944363phoenix
phon95925383pho__n
phonal11310383phonal
phonate12411813phonate
phoned124014553phoned
phonemes1546193phonemes
phones114121213phones
phoney143612983phoney
phoneyed1743843phoneyed
phoneys15437143phoneys
phonic133315213phonic
phonied133710563phonied
phonier122710633phonier
phonies123717513phonies
phono104917023pho_no
phonon114012033phonon
phonos114114793phonos
phons105221143pho_ns
phony136715443pho_ny
phooey14379233phooey
phorate12413363phorate
phoresy1534653phoresy
phosgene1444103phosgene
phot95534363pho__t
photic133316443photic
photo104417233pho_to
photoed1338913photoed
photog12379813photog
photon1111514833photon
photos113316643photos
phots105418503pho_ts
phrase11109903phrase
phreak1536153phreak
phylae14458733phylae
phyle134111153ph_yle
piece96717993p_iece
pinene82915653pinene
pleb86123813p_leb_
plebes104313623p_lebes
plebs95814583p_lebs
poem86225773p_oe_m
poems95715553p_oems
poesy105014063p_oesy
poet65552903p_oe_t
poets76024443p_oets
poise75127893p_oise
poke105335363p_o_ke
pole65951303p_o_le
pome85636693p_o_me
ponce95222513p_once
pone65747533p_o_ne
poodle93112043poodle
pooed85226243pooe_d
poove104514303p_oove
pope85535613p_o_pe
pore66451263p_o_re
pose66441733p_o_se
posse74722273p_osse
pree67044733p_re_e
prese75228383p_rese
probed114114823probed
prober104516073prober
probes104119453probes
proem94818273proe_m
proems104711163proems
proette9312363proette
prole74527793pro_le
prone75332623pro_ne
propene112716043propene
prose75835123pro_se
protege1059153protege
prove104823193pro_ve
psoae74411623pso_ae
puree74632843pure_e
pyrene113210733pyrene
rheme106214053rh_eme
rhomb12399803rhomb_
rhombi13365203rhombi
rhombs13336493rhombs
robe65335643_ro_be
sheeve123412843sheeve
shoe75933443sho__e
shoebox1943623shoebox
shoed95723013shoe_d
shoer84722163shoe_r
shoers94518333shoers
shoes85429663shoe_s
shone83725983sho_ne
shoppe133110323shoppe
shore85432653sho_re
shote85526103sho_te
shove114421043sho_ve
sphene113412403sph_ene
sphere113313663sph_ere
thebes115914493th_ebes
thee78039063th_e_e
theme105921733th_eme
there87527393th_ere
these86519013th_ese
thieve1235963thieve
thole85620843tho_le
thorpe113610093thorpe
those85218143tho_se
three87526913thre_e
uphove1436133upho_ve
whee105429593wh_e_e
wheeze21276823wheeze
where117019433wh_ere
whoever1634103whoever
whole114418093who_le
whore116018043who_re
whose114914533who_se
zoeae144412483_zoeae

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.440406115.9
2DLD Change Limit1127162045.54620323.8
3Display Results2042040.0603400.0
 (SQL Overall)1786912046.04629555.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.