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

129 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
calcify173587(None) 
calcic9311872calci_c
calcific1445022calcific
calcine11315272calcine
calcite11413782calcite
calcium1368592calcium
calif104929102cal_if_
califs114915892cal_ifs
carnify1555882carnify
clarify1536092clarify
coalify1536682coal_ify
crucify1744062crucify
decalcify2041942decalcify
dulcify1643022dulcify
falsify1643612falsify
fancify1834982fancify
pacify1667472pa_cify
salify12311372sal_ify
salsify1334702salsify
acetify1545003acetify
acidify1645243acidify
acidy117214893_a_cidy
aerify122810113_aerify
alcid85817973_alci_d
alcids94812293_alcids
alif76242143_al_if_
alifs86121263_al_ifs
balcony1435853balcony
balkily16266693balkily
balmily14216463balmily
basify1437513ba_sify
caducity1643883caducity
cagily12411563ca_gily
caitiff1547133caitiff
calamity1547753calamity
calcar10312753calc_ar
calcars11312653calcars
calces104420053calc_es
calcified1746893calcified
calcifies1638923calcifies
calcifuge1751993calcifuge
calcifying2144493calcifying
calcined1338743calcined
calcines12314753calcines
calcites12313003calcites
calcitic1148193calcitic
calciums1446163calciums
calctufa1552073calctufa
calctuff1842513calctuff
calculi1146563calculi
calf96339563cal__f_
calfs104919383cal__fs
calices114321693calices
caliche14329953caliche
calicle113111433calicle
calico103414433cal_ico
calicos113913493calicos
caliph13311403cal_iph
calix145317353cal_i_x
calkin123515493calki_n
calking144617783calking
calkins133814873calkins
callboy1465833callboy
calling103826773calling
calming123915973calming
calmly1337613cal_mly
calory11312843cal_ory
calumny1443863calumny
calvary1537183calvary
calving134113503calving
calycine1546963calycine
campily1638273campily
cannily1239263cannily
capacity1746023capacity
casefy1436273ca_sefy
catchfly2143333catchfly
catchy16559583catc_hy
cattily123210853cattily
cavity14310013ca_vity
cecity1398153c_ecity
certify1546243certify
chalcid1537883chalci_d
chalcids1635893chalcids
chancily1845243chancily
citify1437443c_itify
clarity12310913clarity
classify1644693classify
cliff135917133c_l_iff
cliffy17435243c_liffy
clift106422193c_l_ift
codify1537163c_odify
colicky1835783colicky
cornify1536253cornify
damnify1643453damnify
dandify15245673dandify
falsity1335903falsity
fancily1538253fancily
gasify1336333ga_sify
jellify2054543jellify
jollify2044263jollify
kalif125021363kal_if_
kalifs134410983kal_ifs
lacily11612763la_cily
magnify1634533magnify
mollify1555503mollify
nazify2134233na_zify
nullify1334713nullify
opacify1743653opacify
paucity1435823paucity
qualify2235473qual_ify
racily11715173ra_cily
ramify14268753ra_mify
rarify123210063ra_rify
ratify122610043ra_tify
raucity1235853raucity
salacity1347853salacity
saltily10310543saltily
sanctify1644493sanctify
saucily1237913saucily
scarcity1545093scarcity
scarify1537443sca_rify
silicify1644273silicify
specify1764993specify
tackify1934493tackify
talcing103111633talcing
talcky15294723talc_ky
uglify1333913ugl_ify
vilify1536773vil_ify
zincify2443913zincify

Search took 7 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.1431249587.4
2DLD Change Limit1340271296.75019855.9
3Display Results1291290.0462804.3
 (SQL Overall)1786911296.93925751.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.