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

108 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
saponine103922(None) 
saponin9310261saponin_
saponines1148041saponines
saponins1039451saponins
saponite10410531saponite
caponize2139112caponize
pavonine1346662pavonine
saponify1644182saponify
saponites1139942saponites
aconite9315473_aconite
adenine8311213_adenine
agonise83112693_agonise
agonize172911403_agonize
alanine7316863_alanine
apocrine1246933_apocrine
apolune945283_apolune
aproning11311793_aproning
asinine7310723_asinine
atoning83514873_atoning
baronne938263baron_ne
canine83826703ca__nine
canonise10511093canonise
canonize1959833canonize
caponier1237883caponier
caponized2347073caponized
caponizes2238703caponizes
caprine11314233cap_rine
conine84528553__conine
deponing121211213deponing
falconine1445173falconine
gasoline938523gasoline
imponing1338773imponing
japanize2645283japanize
japonica19114033japonica
kaoline11310143ka_oline
lanoline8311953lanoline
leonine7311233_leonine
leporine1049303leporine
masoning1139763masoning
masonite1049683masonite
papyrine1546053papyrine
pontine92419053__pontine
pyronine1349513pyronine
rapine85023083rap__ine
sabine84020393sa__bine
safranine1244803safranine
saining83621393sa_ining
salicine10311703salicine
saline65132703sa__line
salinize1739683salinize
saltine75018563sa_ltine
sanguine947633sanguine
sanidine939853sanidine
saning75127643sa__ning
santonin849703santonin_
santonins948453santonins
sapling103217863sap_ling
sapogenin1254163sapogenin_
sapogenins1353223sapogenins
saponated1245733saponated
saponified1643493saponified
saponifier1542973saponifier
saponifies1544703saponifies
sapote8314363sapo__te
sapphire1543803sapphire
sapping123519313sap_ping
saprolite1147833saprolite
sardine83317393sa_rdine
saturnine944203saturnine
savine94220283sa__vine
savoring1269483savoring
saxonies1537913saxonies
scapolite1346243scapolite
seasoning1037413seasoning
sepaline10311343sepaline
serotine8313573serotine
simonize1947813simonize
siphoning1546133siphoning
solanine8311533solanine
sozine15712353s__ozine
spanning113311083spanning
spawning14296913spawning
spine76534423s_p__ine
spline86020533s_p_line
spoking143212223s_poking
spondee10310593s_pondee
sponge939663s_pon_ge
spongin1036373s_pongin_
sponging1238823s_ponging
spongins1136563s_pongins
spooning112811443spooning
sporing104319413s_poring
stanine73417073s_tanine
stoning83717443s_toning
supine84216693sup__ine
swooning12278203swooning
syphoning1845393syphoning
taborine102510683taborine
taconite1049313taconite
tamponing1445993tamponing
tapeline10310363tapeline
thionine1187923thionine
vaporing1437653vaporing
vaporise13209633vaporise
vaporize22239173vaporize
wagoning1336923wagoning
weaponing1545383weaponing
weaponize2364403weaponize

Search took 9 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 Limit1461621088.08018089.4
3Display Results1081080.0462347.8
 (SQL Overall)1786911088.54920902.0
 
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.