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

260 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
chalone1231210(None) 
chalones13312171chalones
abalone938902abalone
alone55732962__alone
calzone1848622c_alzone
chaconne1543932chaconne
chaine115119222cha_ine
chalice14311042chalice
challie124012852challie
chalot113020132chalo_t
chaloth15298602chaloth
chayote1536492chayote
chinone12510162chinone
choline122915382choline
clone75728162c__lone
colone85425002c_olone
cyclone1437242cyclone
halon86124862_halon_
halons95720712_halons
abalones1038753abalones
agone65924553__agone
alane56135613__alane
aline57243153__aline
aloe45540193__alo_e
along65419493__along
amarone9311203amarone
atone56527983__atone
axone125918473__axone
baloney1237483_baloney
cajole154011183c_ajole
cajon144513903c_ajon_
cajones163311333c_ajones
calcine11315273c_alcine
callee84327293c_allee
callose9313663callose
calo64936443c_alo__
calomel1138073c_alomel
calorie92716903c_alorie
calory11312843c_alory
calos74431903c_alo_s
calotte9510563c_alotte
caloyer1238143c_aloyer
calque17289843c_alque
calve105919923c_al_ve
calzones1948763c_alzones
cane66653123c_a__ne
canine83826703c_anine
canoe75627253c_ano_e
canon74725303c_anon_
canons85522063c_anons
canzone1858813canzone
capon95221873c_apon_
capons104119503c_apons
capote10315733c_apote
carline93923623carline
cauline92215603cauline
chabouk1844543chabouk
chaconnes1644003chaconnes
chador1238673chado_r
chadors1338753chadors
chaetae1238603chaetae
chafe135117353cha__fe
chafing163911493chafing
chain105723673cha_in_
chained133812693cha_ined
chaines124518733cha_ines
chains114819703cha_ins
chaise114916413cha_ise
chalah143511663chal_ah
chalahs15289883chalahs
chalaza2145733chalaza
chalazae2244423chalazae
chalcid1537883chalcid
chalcogen1743763chalcogen
chaldron1445773chaldron_
chaldrons1545493chaldrons
chaleh143711993chal_eh
chalehs15268803chalehs
chalet113825993chal_et
chalets122813473chalets
chaliced1637043chaliced
chalices15310813chalices
chalk144814603chal__k
chalked17449863chalked
chalkier1736753chalkier
chalking183310063chalking
chalks155412143chal_ks
chalky18468773chal_ky
challa114014193chal_la
challah15458323challah
challas124414123challas
challenge1543623challenge
challies133915643challies
challis124613463challis
challot123613263challot
challoth16316103challoth
chally144314293chal_ly
chalupa1444473chalupa
chalutz2195093chalutz
chamade15138453chamade
chamise143612853chamise
chamois143512193chamois
chamoix21275643chamoix
chance134617093cha_nce
chancre14348783chancre
chang115418563cha__ng
change124116753cha_nge
channel123910493cha_nnel
chanoyu1544483chanoyu
chanson1238043chanson_
chansons1337473chansons
chant105932693cha__nt
chao95727313cha_o__
chaos105622863cha_o_s
chaoses124715123cha_oses
chape125221143cha__pe
chaperone1646563chaperone
chapmen1637283chapmen
chappie16298663chappie
charade13129913charade
chare105231983cha__re
charge125114213cha_rge
charing133721323charing
charlie123011923charlie
charlock1944393charlock
charlotte1443803charlotte
charnel124010053cha_rnel
chase105127123cha__se
chasing133715893chasing
chasse115114603cha_sse
chaste114617393cha_ste
chasten124312403chasten
chaunt11613493cha_unt
chawing164813033chawing
chayotes1636503chayotes
chazan20269133chazan_
chazans21268123chazans
chazzen20214783chazzen
chegoe1237273chego_e
chelae113614613chel_ae
chelate122914903chelate
cheloid13310833cheloid
chicalote16123813chicalote
chicane1489553chicane
chigoe1237533chigo_e
childe124711213chil_de
chile105626893chil__e
chinbone1555163chinbone
chine105231723ch__ine
chinones13510483chinones
chiton112612393chiton_
chitons122611913chitons
chlorine133013303ch_lorine
choke145118023ch__oke
cholate122114933cholate
cholent12313253cholent
cholines132214493cholines
cholo105217973cholo__
cholos114716853cholo_s
chon96627793ch__on_
choose115116143ch_oose
chopine143512263chopine
chore105126763ch__ore
chorine123218363chorine
chose105925403ch__ose
chrome133214813ch_rome
chyle134913483chyl__e
chylous15107273chylous
cladode1134613cladode
claxon1536583claxon_
claxons1635803claxons
cline76428533c__line
clon66232483c__lon_
cloned94518803c__loned
cloner84418093c__loner
clones84526563c__lones
clonk114417443c__lonk
clons75228133c__lons
close76425223c__lose
clove105619443c__love
cloze165517543c__loze
coalhole1345093coalhole
coaling103722823coaling
coelome1139693coelome
cologne1039363c_ologne
colon78630193c_olon_
colonel94213283c_olonel
colones96124433c_olones
coloni85619203c_oloni
colons86028683c_olons
colony115417273c_olony
compone136517193compone
condone102616293condone
cone67256963c___one
crane75331603cra__ne
craton84517193craton_
cratons94316033cratons
crayon114110003crayon_
crayoned1435003crayoned
crayoner1344863crayoner
crayons12439233crayons
crone75231333c__rone
cutline92914543cutline
cyanine122911513cyanine
cyclones1537483cyclones
echelon1276163echelon_
echeloned1543443echeloned
echelons1385543echelons
etalon648973etalon_
etalons739073etalons
flavone1335523flavone
galore73514873_galore
halazone2046113_halazone
hale76052833_hal__e
halftone1445163_halftone
halide103417993_halide
haling104229783_haling
halite93624233_halite
halo76437323_halo__
haloed104717603_haloed
haloes94623863_haloes
halogen1138393_halogen
haloid104317763_haloid
haloing113814133_haloing
halos85230253_halo_s
halve114818923_hal_ve
hambone1439313_hambone
haole84820083_ha_ole
haplont12412563_haplont
hexone16289233_hexone
hone77549323_h__one
hyaline132310723hyaline
kalong1177703_kalong
lone45849133___lone
maline84529093_maline
ochone11311293och__one
opaline9412483opaline
phalange1465193phalange
phalanx1945203phalanx
phone105621933ph__one
phylon14318033phylon_
praline93019743praline
saline65132703_saline
salon55228553_salon_
salons63823693_salons
scalene9310773scalene
shale85332833shal__e
shalom11810923shalo_m
shaloms1288983shaloms
shone83725983sh__one
talon55824113_talon_
taloned8310223_taloned
talons64019443_talons
thane86122533tha__ne
throne98517603th_rone
valine94623093_valine
violone1037153violone
whale115517433whal__e
whalebone1753353whalebone
whaling143910773whaling

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.393454684.5
2DLD Change Limit1340272607.64017542.8
3Display Results2602600.0932795.7
 (SQL Overall)1786912608.12621990.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.