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

150 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
tycoon113602(None) 
tycoons1235171tycoons
cocoon10312262cocoon
coon67248942__coon
racoon83814472racoon
toon47740632t__oon
typhon1436672typhon
typhoon1544652typhoon
aboon74918703_aboon
acorn75616623_acorn
ancon75718233anc_on
archon11311753archon
aswoon947013aswoon
baboon103613913baboon
bacon95620593bac_on
beckon14309383beckon
bicorn103610103bicorn
bicron103710773bicron
boon67142173__boon
chon96627793__chon
cion613330913__cion
clon66232483__clon
cocoons11310563cocoons
codon86522853__codon
cogon89120903__cogon
coin66645353__coin
colon78630193__colon
con510268023__c_on
conn66229133__conn
coo59566363__coo_
coof96643273__coof
cook107236933__cook
cool66940493__cool
coons76737283__coons
coop87238653__coop
coos67456493__coos
coot67860383__coot
corn69945813__corn
croon75522783_croon
cyclin1339273cyclin
cyclo1237703cyclo_
cyclone1437243cyclone
cyclos1338073cyclos
cyton101511463cy_ton
dacron94310693dacron
dahoon1039053dahoon
etymon1134693ety_mon
gaboon93211773gaboon
goon57236173__goon
gyron95314623gy_ron
hyson1138693hy_son
icon66922043_ic_on
kroon94514483_kroon
lagoon7410483lagoon
loon47344793__loon
lycopod1543713lycopod
macon94519953mac_on
macron103615673macron
maroon83118203maroon
micron103714283micron
moon67140813__moon
neocon836713neocon
noon47134623__noon
nylon82910513ny_lon
pocoson1156753pocoson
poon67341263__poon
puccoon1343503puccoon
pylon103614003py_lon
python1447143python
raccoon1176163raccoon
racon75422143rac_on
racoons93912433racoons
ratoon64417373ratoon
reckon123010543reckon
recoin84320293recoin
recon75624243rec_on
recook125513923recook
rockoon1345653rockoon
saloon64418023saloon
scion72214993_scion
scoop95617163_scoop
scoot75729143_scoot
scorn75817443_scorn
shoon84022003_shoon
simoon858063simoon
soon46240503__soon
spoon74719443_spoon
swoon85014783_swoon
syphon1436853syphon
taboo73418093taboo_
taboos83815423taboos
tachyon1544623tachyon
taco67031353tac_o_
tacos77023553tac_os
taction93213023taction
talion6317713talion
talon55824113t_alon
tampon102911233tampon
tarpon82812803tarpon
tauon54816583t_auon
taxon124414663t_axon
techno1135953techno
teflon937453teflon
telson6310293telson
tendon7312033tendon
tenon53320513t_enon
teston6313303teston
testoon748363testoon
thorn85318703t_horn
thoron94713903thoron
thrown1214911443thrown
tictoc1036003tictoc
tiglon737913tiglon
tigon63914443t_igon
tocsin8311003tocsin
ton310265103t___on
too38965423t__oo_
took86531073t__ook
tool46735683t__ool
toom66532933t__oom
toons55027533t__oons
toot45958883t__oot
torchon1237363torchon
torn46044253t__orn
town76928703t__own
toyon86715673t_oyon
tricorn937963tricorn
trigon74513103trigon
triton63914893triton
trogon73611753trogon
troop76417533t_roop
trooz145016153t_rooz
tuchun1145443tuchun
turion6313163turion
turnon638193turnon
tyin76424003ty__in
tyiyn11635333ty_iyn
tylosin1046903tylosin
tympan13257013tympan
typhons1537083typhons
typhoons1644563typhoons
typo95418123ty_po_
typos106015813ty_pos
tyro76622363ty_ro_
tyros85118593ty_ros
uncool8610113uncool
yapon104613583_yapon
yon67348953_y__on
yupon10469483_yupon
zoon137326983__zoon

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 Filter1786911127160.1701051123.5
2DLD Change Limit1127161506.54617219.1
3Display Results1501500.0632381.0
 (SQL Overall)1786911506.77926359.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.