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

135 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
tycoons123517(None) 
tycoon1136021tycoon_
cocoons11310562cocoons
coons76737282__coons
racoons93912432racoons
toons55027532t__oons
typhons1537082typhons
typhoons1644562typhoons
acorns85013013_acorns
archons12311583archons
baboons113211083baboons
bacons104917583bac_ons
beckons15279143beckons
bicorns11338763bicorns
bicrons113410473bicrons
boons75031913__boons
cions75222853__cions
clons75228133__clons
cocoon10312263cocoon_
codons96119463__codons
cogons96818113__cogons
coins75834553__coins
colons86028683__colons
conns75024233__conns
cons66057693__c_ons
coofs105924713__coofs
cooks115429143__cooks
cools75632633__cools
coon67248943__coon_
coops96229643__coops
coos67456493__coo_s
coots75636843__coots
corns76034763__corns
croons85418423_croons
cyclins1438303cyclins
cyclone1437243cyclone
cyclones1537483cyclones
cyclops1635383cyclops
cyclos1338073cyclo_s
cytons111710183cy_tons
dacrons103211033dacrons
dahoons1137753dahoons
etymons1244153ety_mons
gaboons10289903gaboons
goons65326773__goons
gyrons105511223gy_rons
hysons1237633hy_sons
icons76516493_ic_ons
kroons103711243_kroons
lagoons839253lagoons
loons55731723__loons
lycopods1643733lycopods
macons104017243mac_ons
macrons113514893macrons
maroons92615553maroons
microns113814783microns
moons75331003__moons
mycoses1437733mycoses
mycosis1437763mycosis
neocons936913neocons
noons54125283__noons
nylons9267973ny_lons
pocosons1266103pocosons
poons75430973__poons
puccoons1443403puccoons
pylons113011243py_lons
pythons1537363pythons
raccoons1265453raccoons
racons84319343rac_ons
racoon83814473racoon_
ratoons73815473ratoons
reckons13269653reckons
recoins94019243recoins
recons84922993rec_ons
recooks134711233recooks
rockoons1445003rockoons
saloons74415323saloons
scions82612243_scions
scoops105414363_scoops
scoots85315943_scoots
scorns85713023_scorns
simoons937943simoons
spoons84116023_spoons
swoons94511143_swoons
sycoses1249133sycoses
sycosis1238823sycosis
syphons1537503syphons
taboos83815433taboo_s
tachyons1644623tachyons
tacos77023553tac_o_s
tactions102912423tactions
talions7314113talions
talons64019443t_alons
tampons112711563tampons
tarpons92612213tarpons
tauons63412673t_auons
taxons134211503t_axons
technos1236183technos
teflons1036543teflons
telsons739223telsons
tendons8311473tendons
tenons62916603t_enons
testons7313563testons
testoons837323testoons
thorns95314103t_horns
thorons104511913thorons
tictocs1145903tictocs
tiglons837343tiglons
tigons74112263t_igons
tocsins939963tocsins
tons46553053t___ons
tools55325243t__ools
toon47740633t__oon_
toots55331873t__oots
torchons1337503torchons
towns86018883t__owns
toyons95512133t_oyons
tricorns1036683tricorns
trigons84312093trigons
tritons73814883tritons
trogons83410723trogons
troops85712783t_roops
tuchuns1233983tuchuns
turions7311573turions
turnons737863turnons
tylosins1145723tylosins
tympans14236813tympans
typhon1436673typhon_
typhoon1544653typhoon_
typhous1566323typhous
typos106015813ty_po_s
tyros85118593ty_ro_s
yapons114411773_yapons
yupons11398353_yupons
zoons144919693__zoons

Search took 7 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.390458182.1
2DLD Change Limit1340271356.32621186.7
3Display Results1351350.0462934.8
 (SQL Overall)1786911356.76226425.8
 
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.