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 “phone” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

130 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
phone10562193(None) 
hone77549321_hone
phon95925381phon_
phoned124014551phoned
phones114121211phones
phoney143612981phoney
phono104917021phono
phons105221141phons
phony136715441phony
pone65747531p_one
prone75332621prone
shone83725981shone
agone65924552agone
alone55732962alone
atone56527982atone
axone125918472axone
bone65949322_bone
chine105231722chine
choke145118022choke
chon96627792chon_
chore105126762chore
chose105925402chose
clone75728162clone
cone67256962_cone
crone75231332crone
dhole95215362dhole
done55747912_done
drone65324982drone
gone55639042_gone
hoe67562722_ho_e
hoke115935932_hoke
hole77553392_hole
home98042442_home
hon67759382_hon_
honed95332262_honed
honer85332092_honer
hones88144492_hones
honey115629912_honey
hong85833952_hong
honk116931192_honk
hons77350782_hons
hope96639672_hope
hose76547242_hose
hove107132222_hove
howe106734102_howe
irone55126362irone
krone94018732krone
leone55018822leone
lone45849132_lone
none45743172_none
ochone11311292ochone
one37050912__one
ozone14310612ozone
pane64950292p_ane
panne76623652panne
penne75423852penne
peon65635242peon_
peones83821042peones
peons75327182peons
peony105717562peony
phage115113672phage
phase104617212phase
phocine1438832phocine
phoebe1335002phoebe
phonal11310382phonal
phonate12411812phonate
phoneme1446202phoneme
phoneys15437142phoneys
phonic133315212phonic
phonied133710562phonied
phonier122710632phonier
phonies123717512phonies
phonon114012032phonon
phonos114114792phonos
phooey14379232phooey
phot95534362pho_t
photo104417232photo
phots105418502phots
phyle134111152phyle
pine67755722p_ine
pion67235302pion_
pions75826392pions
plane74929142plane
plonk114613982plonk
poke105335362p_oke
pole65951302p_ole
pome85636692p_ome
ponce95222512p_once
pond75530492p_ond
pones74547042p_ones
pong76231142p_ong
pons65850602p_ons
pony96434052p_ony
poon67341262poon_
poons75430972poons
poove104514302poove
pope85535612p_ope
pore66451262p_ore
pose66441732p_ose
probe94320812probe
prole74527792prole
prong85218112prong
prose75835122prose
prove104823192prove
prune75119632prune
psoae74411622psoae
pyrone112714472pyrone
scone74621832scone
shine85533092shine
shoe75933442sho_e
shore85432652shore
shote85526102shote
shove114421042shove
sone46649982_sone
sphene113412402sphene
stone55431182stone
thane86122532thane
thine85026862thine
thole85620842thole
thong95014182thong
those85218142those
throne98517602throne
tone46953742_tone
trone55131862trone
uphove1436132uphove
whine116022812whine
whole114418092whole
whore116018042whore
whose114914532whose
zone135231082_zone

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001301.59333772.8
3Display Results1301300.0304333.3
 (SQL Overall)1786911301.93692299.1
 
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.