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

110 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
calycle1424583(None) 
calicle113111431calicle
calycles15295691calycles
caleche14297942caleche
caliche14329952caliche
calicles123811432calicles
calycate1537892calycate
calyces14428802calyces
calycine1546962calycine
calyculi1542152calyculi
caulicle1245042caulicle
cycle1239522c__ycle
alible8311973_alible
allele64514563_allele
bicycle1643993bicycle
cable95329913ca__ble
cache125122483ca__che
cackle143416923ca_ckle
cadelle1039923cadelle
cajole154011183ca_jole
calcar10312753cal_car
calces104420053cal_ces
calcic9311873cal_cic
calcicole1244443calcicole
calcine11315273calcine
calcite11413783calcite
calculi1146563calculi
caleches15269933caleches
calibre1136603calibre
calices114321693calices
caliches153812263caliches
calico103414433calic_o
calicoes123911593calicoes
calicos113913493calicos
calipee11412913calipee
call66838673cal__l_
calla74827073cal__la
callable12310753callable
called94126733cal__led
callee84327293cal_lee
caller85125483cal__ler
callet84536763cal__let
callose9313663callose
calls75634733cal__ls
calmly1337613cal_mly
calomel1138073calomel
calorie92716893calorie
calotte9510563calotte
calque17289843cal_que
calve105919923cal__ve
calyceal1543043calyceal
calycular1643483calycular
calyculus1642243calyculus
calypso1443123calypso
calypter1544063calypter
calyx17518193caly__x
calyxes19426233calyxes
calzone1848623calzone
cancel105316683ca_ncel
candle94321483ca_ndle
canticle1239703canticle
cantle84522153ca_ntle
capable13313363capable
capsule1137343capsule
capuche1644433capuche
caracole12310353caracole
carcel105018673ca_rcel
cariole9818343cariole
carle74535703ca__rle
caroche1469243caroche
carpale113414353carpale
caruncle1244713caruncle
castle84918963ca_stle
cattle85118903ca_ttle
caudle93912913ca_udle
caulicles1344383caulicles
cayuse11207763ca_yuse
cellule936523cellule
cenacle1139123cenacle
chalice14311043chalic_e
chicle134312543c_hicle
chyle134913483c_hy_le
cilice103213353cilic_e
circle1039703c_ircle
clavicle1543603clavicle
cliche133712453c_liche
cloche134312373c_loche
coalhole1345093coalhole
coracle112011723coracle
cubicle1337003cubicle
curlycue1541323curlycue
cuticle1138233cuticle
cycled1436543c__ycled
cycler1335913c__ycler
cycles1339303c__ycles
cyclo1237703c__yclo
lycee104716743__lycee
macle96127003ma__cle
malice104818483malic_e
manacle11310283manacle
palace104516913palac_e
panicle11129983panicle
radicle103510713radicle
recycle1445343recycle
salable91415463salable
sanicle91210263sanicle
scalable121710233scalable
silicle937753silicle
valvule1343663valvule
wavicle1534063wavicle

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271107.09318895.7
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.54523683.4
 
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.