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

226 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
calzone184862(None) 
calzones1948761calzones
canzone1858811canzone
alone55732962_al_one
cabezone2144432cabezone
calcine11315272calcine
callose9313652callose
canzona1836072canzona
canzones1939152canzones
canzonet19410582canzonet
canzoni1836152canzoni
chalone12312102chal_one
clone75728162c_l_one
colone85425002col_one
halazone2046092halazone
abalone938893abal_one
acetone9310793acetone
agone65924553_a_gone
alane56135613_al_ane
alcove1178083_alcove
aldose7311093_aldose
aline57243153_al_ine
alkane104313323_alkane
alkene104114003_alkene
alkine104916803_alkine
alkyne13436863_alkyne
allonge837023_allonge
almond91410433_almond
almoner949383_almoner
aloe45540193_al_o_e
along65419493_al_ong
alpine84417373_alpine
alvine94614583_alvine
ancone83916953_ancone
anyone94612733_anyone
atone56527983_a_tone
axone125918473_a_xone
azine146721413_a_zine
azlon144312873_azlon_
azlons154110423_azlons
azole145118033_a_zole
azon135725053_a_zon_
azons146518253_a_zons
azote144416343_a_zote
balcony1435853balcony
ballon84117493ballon_
ballonet10314503ballonet
ballonne1045243ballonne
ballons93916953ballons
baloney1237483bal_oney
bizone1738603_bizone
blazon1736763blazon_
blazoned2044313blazoned
blazoner1944133blazoner
blazons1836163blazons
cabezon2044663cabezon_
cabezones2243783cabezones
cabezons2144543cabezons
caboose1138273caboose
cajole154011183ca_jole
cajon144513903ca_jon_
cajones163311333ca_jones
calamine12314023calamine
calcanea1276273calcanea
calcanei1265263calcanei
calcined1338743calcined
calcines12314753calcines
calcite11413783calcite
caldron1038153caldron_
caldrons1138063caldrons
caleche14297943caleche
calibre1136603calibre
caliche14329953caliche
calicle113111433calicle
calipee11412913calipee
calkin123515493calkin_
calking144617783calking
calkins133814873calkins
callan83619603callan_
callans94518473callans
callant94121223callant
callee84327293cal_lee
calling103826773calling
calliope1256223calliope
calloses10313383calloses
callous93516593callous
callow114714663callo_w
callower13159073callower
calming123915973calming
calo64936443cal_o__
calomel1138073cal_omel
calorie92716883calorie
calory11312843cal_ory
calos74431903cal_o_s
calotte9510563calotte
caloyer1238143cal_oyer
calque17289843cal_que
calumny1443863calumny
calve105919923cal__ve
calving134113503calving
calycine1546963calycine
calycle14245833calycle
camion103917193camion_
camions113916133camions
campong14318123campong
cane66653113ca___ne
canine83826703ca_nine
cannon84514443cannon_
cannoned11118133cannoned
cannons94412883cannons
canoe75627253ca_no_e
canon74725303ca_non_
canons85522063ca_nons
canton85722993canton_
cantoned111411523cantoned
cantons95221203cantons
canyon114512033canyon_
canyons124511593canyons
canzonas1935383canzonas
canzonets2044483canzonets
capon95221873ca_pon_
capons104119503ca_pons
capote10315733ca_pote
caprine11314233caprine
capstone1237653capstone
carbine112918643carbine
carbon104919043carbon_
carbons115418943carbons
cardon94120853cardon_
cardons104519933cardons
cariole9818343cariole
carline93923613carline
carmine112918483carmine
carton84522663carton_
cartoned111312833cartoned
cartons94122473cartons
caseose939163caseose
caserne93710063caserne
cassene93111543cassene
cassine93817283cassine
cathode1338993cathode
cation83925503cation_
cations94524143cations
cauline92215603cauline
cayenne1244603cayenne
chalones13312173chal_ones
chinone12510153chinone
cladode1134613cladode
claxon1536583claxon_
claxons1635803claxons
cleome1039083c_leome
cline76428533c_l_ine
clon66232483c_l_on_
cloned94518803c_l_oned
cloner84418093c_l_oner
clones84526563c_l_ones
clonk114417443c_l_onk
clons75228133c_l_ons
close76425223c_l_ose
clove105619443c_l_ove
cloze165517543c_l_oze
coalhole1345093coalhole
cologne1039353cologne
colon78630193col_on_
colonel94213283col_onel
colones96124433col_ones
coloni85619203col_oni
colons86028683col_ons
colony115417273col_ony
compone136517193compone
condone102616293condone
cone67256963c___one
crone75231333c__rone
cyclone1437243cyclone
dalton7311273dalton_
daltons8310403daltons
dapsone1038463dapsone
evzone1894683_evzone
falcon11310293falcon_
falconer1346033falconer
falconet13410353falconet
falcons1239123falcons
fanzine1937123fanzine
flavone1335523flavone
gallon73715813gallon_
gallons83015943gallons
galore73514843gal_ore
halazones2145983halazones
halftone1445153halftone
halon86124863hal_on_
halons95720713hal_ons
hambone1439313hambone
jawbone19134443jawbone
kalong1177703kal_ong
lactone9311393lactone
ladrone83611873ladrone
leone55018823__leone
lone45849133__l_one
madrone102812663madrone
maline84529083mal_ine
maltose939783maltose
naloxone1543003naloxone
ozone14310613__ozone
padrone102512073padrone
ralline73518413ralline
rezone153814783_rezone
saline65132703sal_ine
salmon84614183salmon_
salmons93713253salmons
salon55228553sal_on_
salons63823683sal_ons
saloon64418023saloon_
saloons74415303saloons
saltine75018563saltine
scalene9310773scal_ene
subzone1846993subzone
sulfone1037483sulfone
tailbone1045483tailbone
talcose938133talcose
talion6317713talion_
talions7314093talions
talon55824113tal_on_
taloned8310223tal_oned
talons64019423tal_ons
valine94623093val_ine
zone135231083___zone

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340272267.81317154.4
3Display Results2262260.0932430.1
 (SQL Overall)1786912268.05922172.9
 
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.