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

103 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
acerbic133565(None) 
acerb9312762acerb__
acerber1135252acerber
acerbity1544272acerbity
acetic10314502ace_tic
aerobic11310212a_erobic
alembic1354772alembic
amebic1239112ame_bic
anergic1048112anergic
ascorbic1443332ascorbic
ceric94023092_cer_ic
terbic10410962_terbic
unacerbic1551962unacerbic
acari75020283acar_i_
acarid95017073acar_id
acaroid103512313acaroid
acedia9310403ace_dia
acentric1247543acentric
acequia1844143acequia
acerate92818913acerate
acerbate1247533acerbate
acerbest1245463acerbest
acerola947833acerola
acerose9310903acerose
acerous9513343acerous
acetin8314693ace_tin
acetonic1238733acetonic
acetylic1543573acetylic
achromic1747613achromic
acidic113612133ac_idic
acinic104713543ac_inic
aclinic11188973aclinic
acmatic13311703acmatic
acmic11312333ac__mic
acrid86920103ac_r_id
acronic112814693acronic
acrotic112515543acrotic
acrylic1496283acrylic
actinic111810563actinic
acyclic1345573acyclic
aeonic83517043a_eonic
aerie54634603a_er_ie
aerobia939473a_erobia
aerobics1246833a_erobics
agaric93513643agar_ic
alembics1442963alembics
allergic11125383allergic
amoebic1346153amoebic
anaerobic1394393anaerobic
anemic102713693ane_mic
anergia847373anergia
aneroid8314013aneroid
anuric8812113anur_ic
aortic8316613a_ortic
arabic10312733a_rabic
areic73219393a__reic
ascetic11310063asce_tic
aseptic1137373aseptic
atelic8313713ate_lic
atresic9310003atresic
atretic9313923atretic
auric74521743a_ur_ic
axenic154210003axe_nic
cambric1537393cambric
capric12411803capr_ic
cebid104314083_ce_bid
ceramic1339823_ceramic
cerci93716393_cerci_
cercis104614493_cercis
cerebric1444643_cerebric
ceria75125363_cer_ia
cerotic11415063_cerotic
cervid1239323_cervid
cervix1865163_cervix
cherubic1743313cherubic
cleric10612133cler_ic
corbie103618203_corbie
cretic102816283_cretic
cubic114313423_c_ubic
dermic114511913_dermic
ecesic10369223ece_sic
ferric1139993_ferric
gerbil938343_gerbil
herdic123112303_herdic
heroic113516923_heroic
icteric1138033icter_ic
lacertid1146393lacertid
oceanic1146163oceanic
overbid132710273overbid
overbig13237543overbig
racemic1336983race_mic
scenic10510513sce_nic
sceptic1337833sceptic
sorbic10310393_sorbic
spermic1338523spermic
steric8317063ster_ic
terbia8311163_terbia
terebic1137983_terebic
thermic1439333thermic
valeric1238303valer_ic
verbid122311313_verbid
xeric144315663_xer_ic
ytterbic1542373ytterbic

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.406440125.6
2DLD Change Limit1340271036.61020276.4
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.06225303.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.