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

139 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
calorics12281046(None) 
caloric113413221caloric_
calories102919561calories
baldrics13164892baldrics
calorie92716902calori_e
calorize192712742calorize
calorizes202312302calorizes
cambrics1645252cambrics
chloric143410612chloric_
chlorids14299672chlorids
chlorins132612882chlorins
clerics1149332c_lerics
colonics123711612colonics
agarics10319943_agarics
alcaics1137023_alcaics
aldrins8310203_aldrins
aloins65022203_alo_ins
aporias9315153_aporias
atomics113110853_atomics
atonics93613713_atonics
baldric12166403baldric_
baldrick17153623baldrick
baldricks18162883baldricks
bawdrics16153273bawdrics
calcic9311873cal_cic_
caldrons1138063caldrons
calices114321693cal__ices
calico103414433cal__ico
calicos113913493cal__icos
califs114915893cal__ifs
calkins133814873cal_kins
calomels1236133calomels
calorific1643843calorific
calorized21249673calorized
calory11312843calor__y
calos74431903calo___s
calottes10610083calottes
caloyers1337343caloyers
calpacs133110343cal_pacs
calpains1239763calpains
caltraps12327253caltraps
caltrops12307863caltrops
calvarias1447663calvarias
calvaries1449803calvaries
cambric1537393cambric_
camorras12116503camorras
canaries10318943canaries
canonic11312933canonic_
canonries1148413canonries
canopic1338803canopic_
canopies12311853canopies
canorous10310193canorous
cantrips12318933cantrips
caporals1238923caporals
capric12411803ca_pric_
caprice1349683ca_price
caprices1439893ca_prices
capris10415083ca_pri_s
carbolics1546723carbolics
carices114220953ca__rices
caries85147623ca__ries
carotids11229953carotids
carotins102315583carotins
carries94328013ca_rries
catholics16105893catholics
caustics1237483caustics
cavorts1237933cavor_ts
celeriacs1344113celeriacs
celeries10316313celeries
celosias1048903celosias
chlorals13148033chlorals
chlorid133211843chlori_d
chloride143310243chloride
chlorides15289753chlorides
chlorin123113003chlori_n
chlorine133013303chlorine
chlorines142512353chlorines
chlorite133012843chlorite
chlorites142311963chlorites
chlorous1339223chlorous
choric133515903c_horic_
chronics1538683chronics
claries93422203c_laries
classics12418873classics
clastics122811413clastics
cleric10612133c_leric_
clerids1049093c_lerids
clinics11338743c_linics
clitics11279973c_litics
clonic104914673c_lonic_
colics104219903c__olics
colonic115015713colonic_
colonies103620013colonies
coloreds1138093coloreds
colorers10312183colorers
coloring11414843coloring
colorings1247683colorings
colorism122112433colorism
colorisms132810793colorisms
colorist102818993colorist
colorists112313593colorists
colorize192314203colorize
colorizes203014523colorizes
colors86622373color__s
comics124015563c__omics
conics103920593c__onics
cryonics1555413cryonics
culprits1245583culprits
darics94314113da__rics
fabrics1436093fa_brics
florins10311643_florins
galores82614343galor_es
glorias81610323_glorias
glories81915923_glories
haloids113012553halo_ids
illogics1144593illogics
jalopies1786673jalopies
logics95711123__logics
lorica8310443__lorica
lories64933043__lories
loris55329153__lori_s
lyrics11357943__lyrics
malarias10313773malarias
pelorias10410593pelorias
peloric11310713peloric_
pyloric1438063pyloric_
salaries8319593salaries
satoris7317253satori_s
savories11311273savories
taborins103310223taborins
torics85118353__torics
valeric1238303valeric_
valonias1147473valonias
valorise112110313valorise
valorises122210193valorises
valorize20239623valorize
valorizes21249083valorizes
valorous1147373valorous
valors93413773valor__s

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.406440125.6
2DLD Change Limit1461621397.70318974.7
3Display Results1391390.0632206.3
 (SQL Overall)1786911398.17221866.3
 
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.