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 “castanet” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
castanet1041619(None) 
castanets1146331castanets
caftaned1445092caftaned
carcanet12316342carcanet
alkanet113714433_alkanet
askant10412713_askan_t
aslant6317753_aslan_t
basinet9318933bas_inet
bassinet10312843bassinet
cabaret112519043ca_baret
cabernet12410763cabernet
cabinet11318903ca_binet
cabstand1344413cabstan_d
cabstands1453723cabstands
caftan111710123caftan__
caftans12179443caftan_s
calcanea1276273calcanea
calcanei1265263calcanei
callant94121223callan_t
cantoned111411523cantoned
canzonet19410583canzonet
capstan1137903capstan__
capstans1257243capstan_s
capstone1237653capstone_
capstones1347373capstones
captained1446193captained
captan101613343captan__
captans111612053captan_s
carcanets1347303carcanets
carnet84732873ca__rnet
cartage10312593cartage_
cartages11313313cartages
cartoned111312833cartoned
cascabel14174503cascabel
cascade12118603cascade_
cascaded14135703cascaded
cascades13128553cascades
casease939323casease_
caseases10410473caseases
caseate9314783caseate_
caseated11310713caseated
caseates10313703caseates
casement12311953casement
caserne93710063caserne_
casernes103810753casernes
casket124820993cas__ket
cassene93111543cassene_
cassenes103611293cassenes
cassine93817283cassine_
cassines103116613cassines
castable121613973castable
castaway1664573castaway
caste75932363cast__e_
caster85232573cast__er
castes85631863cast__es
casting104628343castin_g
castings113614053castings
castle84918963cast_le_
castled104311513cast_led
castles94917733cast_les
castrate10313863castrate_
castrated1239513castrated
castrater1148523castrater
castrates11312663castrates
cetane8315283c_etane_
cetanes9315133c_etanes
chastened1545883chastened
chastener1445703chastener
constant10515593constan_t
costae85319683costa_e_
costate94019273costate_
cystine1239333cystine_
cystines1339463cystines
distant83519953distan_t
fastened12257853fastened
fastener11227833fastener
hastate10313913hastate_
hastened12239103hastened
hastener11259133hastener
instant7815343instan_t
martinet10319643martinet
natant6318733na_tan_t
pantalet10415903pantalet
passant9813943passan_t
saltant7316773saltan_t
satinet7325283sa_tinet
stane55933003__stane_
staned74824643__staned
stanes64933403__stanes
wastage11109253wastage_
wastages12109753wastages

Search took 8 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.1561145455.1
2DLD Change Limit146162917.58019282.6
3Display Results91910.0303033.3
 (SQL Overall)178691917.76623009.4
 
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.