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

178 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
calvary153718(None) 
alary86123442_al_ary
calamary1545462calamary
calcar10312752calcar_
calcars11312652calcars
calory11312842cal_ory
calvaria1347892calvaria
canary11314692ca_nary
cavalry1554962ca_valry
ciliary1247922ciliary
clary105719612c_l_ary
covary1438742c_ovary
palmary14338552palmary
salary9515212sal_ary
salivary1444732salivary
valvar12388652valvar_
actuary1245613actuary
alar46340073_al_ar_
alarm76621423_al_arm
allay85620393_alla_y
altar55520643_altar_
altars64518153_altars
alway116113923_alwa_y
ambary134010543_ambary
angary10311323_angary
apiary113910383_apiary
ariary94114203_ariary
aviary12338413_aviary
aweary1237303_aweary
balladry1444213balladry
biliary1238213biliary
bleary115112553_bleary
cabbagy1744013cabbagy
caesar8410933caesar_
caesars9410733caesars
calamar1149293calamar_
calamari1246123calamari
calamars1238133calamars
calami10313423cal_ami
calash11312433cal_ash
calcaria1249533calcaria
calcify1735873calcify
caldaria1148953caldaria
caldera1037963caldera
calibre1136603calibre
calker124917083calker_
calkers134414693calkers
calla74827073calla__
callan83619603calla_n
callans94518473callans
callant94121223callant
callas84526753calla_s
callboy1465833callboy
caller85125483caller_
callers94221963callers
calmer105216933calmer_
calmly1337613cal_mly
calpac123211063calpa_c
calpack17338333calpack
calpacs133110343calpacs
calpain11310413calpain
caltrap11297943caltrap
calumny1443863calumny
calvados1444813calvados
calvarial1445693calvarial
calvarian1446863calvarian
calvarias1447663calvarias
calvaries1449803calvaries
calvarium1644773calvarium
calve105919923calv__e
calved125215453calv_ed
calves115119283calv_es
calving134113503calving
canard9314763ca_nard
cannery123610013cannery
canonry1235923canonry
canvas113813333canva_s
canvass12376873canvass
capillary16134263capillary
carbarn1139453carbarn
carbaryl1544423carbaryl
carfare12310073carfare
carry105823783ca__rry
carver114420153carver_
carvers124817543carvers
cascara1138313cascara
catenary1346583catenary
cattery123811603cattery
cautery12349593cautery
cavally1588483ca_vally
caver105629063ca_ver_
cavern115312453ca_vern
cavers115026843ca_vers
caviar11310163caviar_
caviare1238373caviare
caviars1238623caviars
cavitary1664963cavitary
cavity14310013ca_vity
cavort11316173ca_vort
cavy125920003ca_v__y
cedary12419603c_edary
celery1139623cel_ery
cellar84514983cellar_
cellars93713693cellars
chary135023133c__hary
chivalry1943083chivalry
chivari1536043chivari
claro75018693c_l_aro
clavate1238713clavate
claver113816973claver_
clavers124314903clavers
clay95927413c_l_a_y
clear76219053c_lear_
clearly1236663c_learly
clears84116563c_lears
clovery15407403clovery
coalyard1444093coalyard
collar83816173collar_
collard103712923collard
collars93816573collars
culinary1355853culinary
cullay113910173culla_y
culver113010633culver_
culvers12329833culvers
culvert123011773culvert
datary10310243da_tary
fallacy1536433fallacy
flavory1644743flavory
galaxy17476313gal_axy
gallery11468743gallery
glary96018543_gl_ary
halva115414433halva__
halvah15499833halva_h
halvahs16417533halvahs
halvas124714173halva_s
halvers133311423halvers
halyard1476973halyard
jaggary19304863jaggary
lactary1237843lactary
laniary1068013laniary
leary85927383__leary
malady1237863mal_ady
malar76424443mal_ar_
malarky1645433mal_arky
malars85020683mal_ars
mallard10310273mallard
mammary1335993mammary
manuary1237773manuary
miliary1249463miliary
navar83912733na_var_
navars92810573na_vars
olivary1345163olivary
ovary1149113__ovary
palmar104113463palmar_
paltry114910403pal_try
salutary1145113salutary
salvably1645443salvably
salvage1138193salvage
salver94617753salver_
salvers103916003salvers
salvor94711093salvor_
salvors103910913salvors
savory124310563sa_vory
scalar83612433scal_ar_
scalare93311833scal_are
scalars93711903scal_ars
silvery13328093silvery
slavery13407893slavery
talar56225383tal_ar_
talars66021683tal_ars
vagary1337333va_gary
valval12398863valva_l
valvate133710813valvate
vary105226063___vary
vivary1536983_vivary
vulvar12427963vulvar_
wallaby1535073wallaby
wavery154610053wa_very

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.423422437.4
2DLD Change Limit1340271787.04619021.7
3Display Results1781780.0602966.7
 (SQL Overall)1786911787.52923733.7
 
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.