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

102 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
sponson93538(None) 
sponsion1045621sponsion
sponsons1045811sponsons
sponsor934971sponsor
poison8312222_poison
ponton83217642_ponton
spongin1036372spongin
sponsal946342sponsal
sponsions1145222sponsions
sponsors1045752sponsors
spontoon1043782spontoon
spoon74719442spo__on
blouson974893blouson
bolson8410683_bolson
bonbon10310073_bonbon
boson76019733_bo_son
chanson1238043chanson
consol82614113_consol
cosponsor1342593cosponsor
dobson936593_dobson
donjon1436463_donjon
empoison1243843empoison
foison948933_foison
fronton1037203fronton
godson857383_godson
gonion73612833_gonion
johnson1742333johnson
monsoon938493_monsoon
onion54320973__onion
opinion946793opinion
parson83817903_parson
pennon8310643_pennon
pension9412203_pension
person83517873_person
phonon114012033phon_on
pinion83815893_pinion
pinon76024533_pin_on
pinyon11459763_pinyon
pocoson1156753_pocoson
podsol946853_podsol
poisons9310353_poisons
pompon1238943_pompon
pons65850603_pons__
pontons93315553_pontons
pontoon93010703_pontoon
poon67341263_po__on
potion84519573_potion
prison8514023_prison
ronion63315643_ronion
ronyon9309133_ronyon
saponin9310263sapon_in
scansion1045693scansion
season62714903s_eason
sensor63813843s_ensor
shoon84022013sho__on
solion6616383s_olion
solon55026133s_o_lon
sons46049553s_ons__
sonsie6614863s_onsie
sonsy86416373s_ons_y
soon46240503s_o__on
spans74528733spans__
spense83912433spens_e
spenses92913573spenses
spinor839943spin_or
spinose937943spinose
spins75327983spins__
spinto8410663spinto_
spintos939133spintos
spodosol1142223spodosol
spoken124610003spo_ken
spondee10310593spondee
sponge939663spon_ge
sponged1137953sponged
sponger1038523sponger
sponges10311043sponges
sponging1238823sponging
spongins1136563spongins
spongy1236743spon_gy
sponsored1243223sponsored
sponsoring1343633sponsoring
spontoons1153403spontoons
spoof105019013spo__of
spook115416043spo__ok
spool75219043spo__ol
spoons84116023spo__ons
spoony114111793spo__ony
spoor75016353spo__or
sporran936743sporran
spots74424113spots__
spousal965533spousal
spouse84112513spous_e
spoused10349653spoused
spouses92912813spouses
spousing11198733spousing
stemson945163stemson
stepson945673stepson
sternson844843sternson
stetson745783stetson
stolon64112073sto_lon
swoon85014783swo__on
wonton93410963_wonton

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271027.23618522.2
3Display Results1021020.0303400.0
 (SQL Overall)1786911027.67223291.3
 
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.