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

101 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
calycate153789(None) 
calceate1239862calceate
calcite11413782cal_cite
califate13310482califate
calycine1546962calycine
calycle14245832calyc_le
colocate12313442colocate
falcate12311612fal_cate
acrylate1347693acrylate
acylate12310533_acylate
alate55340323_al__ate
alcade91111513_al_cade
alkylate1554663_alkylate
allocate10411023allocate
baccate131011263ba_ccate
baldpate1345483baldpate
calamata1247553calamata
calamite12312533calamite
calcanea1276283cal_canea
calcanei1265273cal_canei
calcar10312753cal_ca_r
calcarate1347703calcarate
calcars11312653cal_cars
calcine11315273cal_cine
calcites12313003cal_cites
calculate1389873calculate
caleche14297943calec_he
calibrate1347743calibrate
caliche14329953calic_he
calicle113111433calic_le
califates14310113califates
caliphate1645293caliphate
calotte9510563cal_otte
calyceal1543043calyceal
calyces14428803calyc_es
calycles15295693calycles
calyculi1542153calyculi
calypter1544063caly_pter
canulate10314553canulate
capitate121712183capitate
carate84734003ca__rate
carcase11312743ca_rcase
cardcase1345973cardcase
carinate103320243carinate
cascade12118603ca_scade
caseate9314783ca_seate
casemate1239843casemate
castrate10313863castrate
catenate10312833catenate
caudate10311353ca_udate
cavitate13159833cavitate
celibate1259313celibate
cellmate1237873cellmate
chalybeate2052013chalybeate
chlorate133112693chlorate
ciliate9514603cil_iate
clavate1238713c_lavate
clayware1643933clayware
climate11312833c_limate
clypeate1543873c_lypeate
collate92919683col_late
collocate1348673collocate
colocated1439613colocated
colocates13312853colocates
copycat1647593copycat_
copycats1745083copycats
cultrate10310873cultrate
daycare1355093da_ycare
delicate11315493delicate
dialysate1343323dialysate
dialyzate2242703dialyzate
falcated1438473fal_cated
galeate83916783gal_eate
gallate83417123gal_late
kalifate1556493kalifate
locate83919843__locate
lyrate94112103__lyrate
lysate9388103__lysate
malate84624553mal__ate
maleate94117543mal_eate
palate84226783pal__ate
paleate94120003pal_eate
palliate10311893palliate
palmate113215233pal_mate
palpate113213923pal_pate
placate11312433_placate
playdate1465263playdate
playmate1566463playmate
plicate11314513_plicate
radicate11412873radicate
relocate10713533relocate
saccate111311763sa_ccate
salivate11310013salivate
silicate10312623silicate
sulcate9314423sul_cate
vacate11314553va__cate
valerate11311473valerate
validate1239003validate
vallate103016563val_late
valuate102512733val_uate
valvate133710813val_vate

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.420425454.8
2DLD Change Limit1461621017.26620115.9
3Display Results1011010.0303366.7
 (SQL Overall)1786911017.71623158.5
 
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.