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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
phoning1331205(None) 
honing103421501_honing
phonying1745831phonying
aproning11311792aproning
atoning83514872atoning
boning94223292_boning
chining133316842chining
choking173911942choking
choring133617662choring
chowing164412772chowing
cloning103215472cloning
coning94331832_coning
droning93013722droning
hoeing104117022_hoeing
hoking144419512_hoking
holing104025072_holing
homing123718382_homing
honking153414792_honking
hoping123719742_hoping
horning113015002_horning
hosing103421102_hosing
ironing82414012ironing
mooning103415552mooning
nooning83014852nooning
paining103920242paining
panning104019392panning
pawning134711412pawning
peening103318302peening
peining104619152peining
penning103616492penning
phasing133211672phasing
phocine1438832phocine
phonating1537812phonating
phoneying1844282phoneying
phonic133315212phoni_c
phonics143110722phonics
phonied133710562phonied
phonier122710632phonier
phonies123717512phonies
phonily1537102phonily
phonon114012032phonon_
phonons123310252phonons
photoing1439072photoing
pining93726532p_ining
pinning103417852pinning
planing103418252planing
plonking15358562plonking
plowing133111722plowing
ploying132811572ploying
poking133819302p_oking
poling93526502p_oling
poncing122913582p_oncing
ponding114317082p_onding
ponging113416152p_onging
ponying133312122p_onying
poohing133112322poohing
pooing93820682p_ooing
pooling103219092pooling
pooping123615442pooping
poring94227272p_oring
posing93922642p_osing
poxing163714942p_oxing
probing123314442probing
pronging123511842pronging
prosing103319382prosing
proving134214072proving
pruning10311732pruning
punning103414992punning
shining113816522shining
shoeing113211882shoeing
shooing112112912shooing
shoring112820072shoring
shoving142910642shoving
showing143814662showing
siphoning1546132siphoning
spooning112811442spooning
stoning83717442stoning
syphoning1845392syphoning
tholing112812332tholing
thorning1237512thorning
thouing11258602thouing
throning1238862throning
toning74025792_toning
whining143311672whining
whoring142910292whoring
zoning162914332_zoning
zooning172910702zooning

Search took 4 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 Filter1786911076710.406440125.6
2DLD Change Limit107671873.11034620.9
3Display Results87870.0302900.0
 (SQL Overall)178691873.54650392.3
 
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.