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

217 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
botanies1031285(None) 
botanise1039641botanise
botanises1139161botanises
botanizes2048421botanizes
beanies93821092b_eanies
betaines10313292betaines
betonies10413062betonies
boonies93422482bo_onies
boranes93720402boran_es
botanic1159582botani_c
botanica1295722botanica
botanicas1365252botanicas
botanised1246392botanised
botanist10412032botanist
botanists1148202botanists
botanize1948752botanize
botanized2147282botanized
botanizer2046242botanizer
botanizers2144282botanizers
botflies1336732botflies
bothies12414782bot_hies
butanes9312742butan_es
litanies8310992litanies
notaries8314932notaries
ratanies8312922ratanies
rotaries8315692rotaries
tetanies8513552tetanies
votaries11312012votaries
astonies8815093astonies
ataxies142410013_ataxies
atonies75320953_atonies
babies106123653b__abies
balances1279973balances
bandies104124863b__andies
banes74945583b__an_es
banties94324763b__anties
baronies10315023baronies
beanie83618593b_eanie_
beatniks1444043beatniks
beladies11310423beladies
bennies93917313b_ennies
betaine9413783betaine_
betakes134212523beta_kes
bialies93618413b_ialies
bigamies1337373bigamies
binaries10314183binaries
biogenies1248513biogenies
blatancies1444373blatancies
blennies1056933blennies
boatings113710113boatings
bobbies103714563bo_bbies
bobtails1245193bobta_ils
boccies133311513bo_ccies
bodies94524143bo__dies
bogans95714813bogan__s
bogies94724313bo__gies
bolases93315003bola_ses
bolshies1338693bolshies
boltonias1145123boltonias
bonacis11310323bonaci_s
bonanzas1943113bonanzas
bones76446533bo__n_es
bonier84321993bo__nier
boniest93318993bo__niest
bonnes85621453bo__nnes
bonnie85314853bo_nnie_
bonnier94711313bo_nnier
bonniest10310773bo_nniest
bonzes175116103bo__nzes
boobies113718203bo_obies
boodies103721443bo_odies
boogies103719013bo_ogies
bookies133819403bo_okies
booteries11312773booteries
booties94124613bo_oties
boraces113716853bora_ces
boracites1347953boracites
borages103917163bora_ges
borane84620213boran_e_
borates94823013bora_tes
boraxes163511633bora_xes
bornites10310983bo_rnites
bossies94116833bo_ssies
botanical1366073botanical
botanicals1493163botanicals
botany1139263botan__y
botas75328783bota___s
botches143716023bot_ches
botchier15287143botchier
botchiest1636153botchiest
botonee9311833boton_ee
botonnee1044693botonnee
bottles94216273bot_tles
botulins1047063botulins
bougies103715183bo_ugies
bounces113813683bo_unces
bounties10311403bounties
bournes93615023bourn_es
bovines12412663bovin_es
boweries13312293boweries
bowlines133211623bowlines
brandies11714563b_randies
braxies16711463b_raxies
brinies93317913b_rinies
brionies10310543brionies
brownies13189613brownies
bryonies1336843bryonies
bunnies94415003b_unnies
buoyances1643353buoyances
buoyancies1742993buoyancies
burnies94017823b_urnies
butane8313653butan_e_
butanols1044713butanols
butanones1144713butanones
butenes9313033buten_es
butties93217953but_ties
byrnies12378573b_yrnies
cetanes9315133cetan_es
cocaines121314443cocaines
colonies103620013colonies
companies15311803companies
conies84338593co__nies
cotans81317923cotan__s
coteries10422703coteries
cotinines11410073cotinines
covaries13413253covaries
dataries9314033dataries
dittanies1045733dittanies
domaines11611063domaines
dominies113513193dominies
dotages92311793dota_ges
ebonies9312883ebo__nies
eutaxies1545793eutaxies
geobotanies1452623geobotanies
goalies8316023go_alies
goonies83618333go_onies
hoagies112811993ho_agies
hominies133012953hominies
hotlines11811643hotlines
hotties103016963hot_ties
ibogaines1243813ibogaines
joannes1436243jo_annes
johannes1842943johannes
johnnies1872993johnnies
joyances2044413joyances
kokanees1143033kokanees
loonies73919543lo_onies
meanies93620743_meanies
monies83233163mo__nies
montanes101114523montan_es
moraines10314363moraines
mutinies10311503mutinies
neotenies948383neotenies
notables10178243notables
notarizes1848713notarizes
notates72817483nota_tes
notifies11310423notifies
obtained1136533obtained
obtainer1045793obtainer
obtainers1144853obtainers
obtains939163obta_ins
octanes91111393octan_es
oogamies1147413oogamies
oogenies9311583oogenies
oranges84215333_oranges
otalgies936393_otalgies
ovaries10312653_ovaries
ponies84833463po__nies
portances1349833portances
potables12179703potables
potages102416423pota_ges
potashes1337833potashes
potatoes1039943potatoes
potences12710693potences
potencies1369303potencies
potlines10714213potlines
potpies113116173pot_pies
potsies93019483pot_sies
potties93723543pot_ties
rhatanies1244983rhatanies
roadies83317443ro_adies
romaines10512523romaines
romances12310793romances
romanise10312133romanise
romanises11311573romanises
romanizes20310933romanizes
rosaries8312783rosaries
rotates72819773rota_tes
sanies63031953__sanies
solanines9310083solanines
solanins8310513solanins
sonances10310263sonances
sonnies7315223so_nnies
soutanes8312933soutan_es
stances93715963_stances
stanes64933403_stan_es
stanines85115673_stanines
tansies74521243__tansies
tawnies102812503__tawnies
taxies135817333__taxies
tetanics10127373tetanics
tetanise8610203tetanise
tetanises979873tetanises
tetanizes1889843tetanizes
titanias847103titanias
titanites997413titanites
toadies82914863to_adies
tolanes74216313tolan_es
toonies73719883to_onies
totalise8312503totalise
totalises9311783totalises
totalizes18311053totalizes
townies103113623to_wnies
womanise1348733womanise
womanises1448063womanises
womanizes2347993womanizes
zanies153219673__zanies

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.420425454.8
2DLD Change Limit1461622177.67319048.9
3Display Results2172170.0762855.3
 (SQL Overall)1786912178.16921874.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.