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

119 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
calycles1529569(None) 
calicles123811431calicles
calyces14428801calyc_es
calycle14245831calycle_
calces104420052cal_c_es
caleches15269932caleches
calices114321692calic_es
caliches153812262caliches
calicle113111432calicle_
calicoes123911592calicoes
calyculus1642242calyculus
calyxes19426232caly_xes
caulicles1344382caulicles
cycles1339302c__ycles
alleles73812033_alleles
bicycles1743883bicycles
cables104527553ca__bles
caches137926913ca__ches
cackles153717203ca_ckles
cadelles1139973cadelles
cajoles163712103ca_joles
calashes13310533calashes
calcars11312653cal_cars
calcicoles1344023calcicoles
calcines12314753calcines
calcites12313003calcites
calculus1255333calculus
caleche14297943caleche_
calibres1237103calibres
caliche14329953caliche_
calicos113913493calic_os
calipees1247413calipees
callas84526753cal__las
called94126733cal__led
callee84327293cal__lee
callees94117783cal_lees
caller85125483cal__ler
callers94221963cal__lers
callet84536763cal__let
callets93821703cal__lets
calloses10313393calloses
calls75634733cal__l_s
callus85317073cal__lus
calluses1039323calluses
calomels1236133calomels
calories102919553calories
calottes10610083calottes
calques182710193cal_ques
calves115119283cal__ves
calxes154113033cal__xes
calycate1537893calycate
calyceal1543043calyceal
calycine1546963calycine
calycular1643483calycular
calyculi1542153calyculi
calypsoes1642823calypsoes
calypsos1543113calypsos
calypter1544063calypter
calypters1643593calypters
calzones1948763calzones
cancels114113313ca_ncels
candles104422343ca_ndles
canticles1339183canticles
cantles94721413ca_ntles
capsules1236623capsules
capuches1735513capuches
caracoles13310073caracoles
carcels114516063ca_rcels
carices114220953caric_es
carioles10817073carioles
carles85435083ca__rles
caroches15710693caroches
caruncles1345003caruncles
castles94917733ca_stles
catches144320773ca_tches
caudles103912813ca_udles
caules85927253ca__ules
caulicle1245043caulicle_
cayuses12188403ca_yuses
cellules1036813cellules
cenacles1238023cenacles
chalices15310813chalic_es
chicles143512503c_hicles
chyles144813283c_hy_les
cilices113814023cilic_es
circles1139903c_ircles
clavicles1643673clavicles
cliches144213743c_liches
cloches144113713c_loches
coalholes1445373coalholes
coracles121811163coracles
cubicles1435883cubicles
culches143710743cul_ches
culices113713123culic_es
cultches15316533cultches
curlycues1641393curlycues
cuticles1237893cuticles
cycle1239523c__ycle_
cycled1436543c__ycled
cycler1335913c__ycler
cyclers1435873c__yclers
cyclos1338073c__yclos
cylices14359283cylic_es
dalles74222063dal__les
falces115216003fal_c_es
kayles134712003ka_y_les
lycees11428863__lycees
lyches144213613__lyches
macles107023223ma__cles
malices114316623malic_es
manacles1239523manacles
palaces114216453palac_es
panicles121010113panicles
radicles11249703radicles
recycles1535353recycles
sanicles10149943sanicles
silicles1037073silicles
valvules1443473valvules
wavicles1633783wavicles

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 Filter1786911461620.470380193.6
2DLD Change Limit1461621197.61019206.6
3Display Results1191190.0462587.0
 (SQL Overall)1786911198.12621990.0
 
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.