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

127 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
saponins103945(None) 
saponin9310261saponin_
saponine1039221saponine
saponines1148041saponines
santonins948452santonins
sapogenins1353222sapogenins
saponify1644182saponify
saponite10410532saponite
saponites1139942saponites
saxonies1537912saxonies
spongins1136562s_pongins
adonis7314063_adoni_s
agonies83016623_agonies
alanins7315803_alanins
aloins65022203_alo_ins
aphonias132611143_aphonias
aphonics15259523_aphonics
aporias9315153_aporias
aproning11311793_aproning
aspirins1037733aspirins
astonies8815093astonies
atonias73315993_atonias
atonics93613713_atonics
atonies75320953_atonies
atoning83514873_atoning
baronies10315023baronies
capelins12311133capelins
caplins113515993cap_lins
caponier1237883caponier
caponiers1345733caponiers
caponize2139113caponize
caponizes2238703caponizes
capons104119503capo__ns
captains121810573captains
carotins102315583carotins
cipolins1238033cipolins
conins84327233__conins
daphnias1444683daphnias
deponing121211213deponing
gaposis1038423gaposi_s
imponing1338773imponing
jacobins1944193jacobins
japonica19114033japonica
japonicas20113253japonicas
kaolins1139363ka_olins
laminins1039133laminins
lanolins8310533lanolins
lapins84520683lap__ins
mahonias1348063mahonias
masoning1139763masoning
napkins1336673nap_kins
opsonins1045533opsonins
papains11312363pap_ains
pavonine1346663pavonine
ponies84833463__ponies
sabins85521983sa__bins
safranins1244353safranins
saimins9312113sa_imins
saining83621393sa_ining
sains55639973sa___ins
salicins10310933salicins
salmonids1245543salmonids
salons63823693salo__ns
saloons74415323salo_ons
sanies63031953sa__nies
saning75127643sa__ning
santonin849703santonin_
sapiens9310173sap_iens
sapling103217863sap_ling
saplings11269803saplings
sapogenin1254163sapogenin_
saponifies1544703saponifies
saporous1039053saporous
sapors84118813sapo__rs
sapotas939613sapo_tas
sapotes9313943sapo_tes
sapours93610623sapo_urs
sapphics1743413sapphics
sapping123519313sap_ping
sarins63932623sa__rins
sarongs84511803saron_gs
sasins64923103sa__sins
satins64930483sa__tins
satoris7317253satori_s
savarins1139893savarins
savins93923133sa__vins
savories11311273savories
savoring1269483savoring
searobins1145553searobins
seasoning1037413seasoning
seasonings1143293seasonings
simonies10311113simonies
siphoning1546133siphoning
solanins8310513solanins
sonics84315633s__onics
sozins15510793s__ozins
spanning113311083spanning
spavins12419323s_pavins
spawning14296913spawning
spins75327983s_p__ins
spoils84614533s_po_ils
spoking143212223s_poking
sponges10311043s_ponges
spongin1036373s_pongin_
sponging1238823s_ponging
sponsions1145223s_ponsions
sponsons1045813s_ponsons
spoonies101911753spoonies
spooning112811443spooning
spoons84116023s_po_ons
sporing104319413s_poring
sprains93013593s_prains
stoning83717443s_toning
stotins73213873s_totins
swooning12278203swooning
syphoning1845393syphoning
taborins103310223taborins
tamponing1445993tamponing
tannins72813223ta_nnins
thionins1177923thionins
troponins1147203troponins
valonias1147473valonias
vaporing1437653vaporing
vaporings1544093vaporings
wagoning1336923wagoning
weaponing1545383weaponing
yapons114411773yapo__ns

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621276.92021121.7
3Display Results1271270.0502540.0
 (SQL Overall)1786911277.39324170.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.