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

139 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
saponin931026(None) 
saponine1039221saponine
saponins1039451saponins
santonin849702santonin
sapogenin1254162sapogenin
saponify1644182saponify
saponines1148042saponines
saponite10410532saponite
spongin1036372s_pongin
adonis7314063_adonis
aeonian738353_aeonian
aeonic83517043_aeonic
agonic93515143_agonic
alanin6317273_alanin
aloin55227423_alo_in
aphonia122711883_aphonia
aphonic142713393_aphonic
aporia8315863_aporia
aproning11311793_aproning
aspirin937823aspirin
atonia63816513_atonia
atonic83420473_atonic
atoning83514873_atoning
axonic154312723_axonic
azonic175513153_azonic
canonic11312933canonic
capelin11510973capelin
caplin103216303cap_lin
capon95221873capo__n
caponier1237883caponier
caponize2139113caponize
capons104119503capon_s
captain112111063captain
carotin92216733carotin
cipolin1148783cipolin
conin76232723__conin
daphnia1345053daphnia
deponing121211213deponing
favonian1442973favonian
gaposis1038423gaposis
imponing1338773imponing
jacobin1844393jacobin
japonica19114033japonica
kaolin1039583ka_olin
kaonic1238763ka_onic
laconic1139883laconic
laminin939973laminin
lanolin7310643lanolin
lapin75222923lap__in
mahonia1238443mahonia
masonic1139913masonic
masoning1139763masoning
napkin1236903nap_kin
opsonin946013opsonin
papain10313793pap_ain
pavonine1346663pavonine
rapini84714683rapini_
sabin74924953sa__bin
safranin1145213safranin
saimin8313663sa_imin
sain45551293sa___in
saining83621393sa_ining
salicin9311223salicin
salmonid1147633salmonid
salon55228553salo__n
salons63823693salon_s
saloon64418023salo_on
saning75127643sa__ning
santonins948453santonins
sapid84720933sap__id
sapling103217863sapling
sapogenins1353223sapogenins
saponites1139943saponites
sapor75119253sapo__r
sapors84118813sapo_rs
sapota8310213sapo_ta
sapotas939613sapotas
sapote8314363sapo_te
sapotes9313943sapotes
sapour83812373sapo_ur
sapours93610623sapours
sapphic1644553sapphic
sapping123519313sapping
saprobic1445263saprobic
sardonic1147453sardonic
sarin55239253sa__rin
sarong73914873saron_g
sarongs84511803sarongs
sasin54626573sa__sin
satanic939933satanic
satin55935223sa__tin
satori6415843satori_
satoris7317253satoris
savarin10310003savarin
savin84625083sa__vin
savoring1269483savoring
saxonies1537913saxonies
saxony1636233saxon_y
searobin1045713searobin
seasoning1037413seasoning
siphonic1547983siphonic
siphoning1546133siphoning
solanin7311943solanin
somoni8310743somoni_
sonic75225293s__onic
sozin14514543s__ozin
spanning113311083spanning
spavin114210653s_pavin
spawning14296913spawning
spin66231303s_p__in
spoil75818653s_po_il
spoken124610003s_poken
spoking143212223s_poking
sponge939663s_ponge
sponging1238823s_ponging
spongins1136563s_pongins
spongy1236743s_pongy
sponsion1045623s_ponsion
sponson935383s_ponson
spoon74719443s_po_on
spooning112811443spooning
sporing104319413s_poring
sprain83614863s_prain
stoning83717443s_toning
stotin63215063s_totin
swooning12278203swooning
syconia1248313syconia
syphoning1845393syphoning
taborin92210453taborin
tamponing1445993tamponing
tannin62613923ta_nnin
thionin1048673thionin
troponin1047943troponin
valonia1048303valonia
vaporing1437653vaporing
wagoning1336923wagoning
weaponing1545383weaponing
yapon104613583yapo__n
yapons114411773yapon_s

Search took 10 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.313570897.8
2DLD Change Limit1340271399.45314178.3
3Display Results1391390.0463021.7
 (SQL Overall)1786911399.81218211.5
 
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.