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

131 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
cambric153739(None) 
cambrics1645251cambrics
caloric113413222caloric
cambia124913152camb_ia
capric12411802ca_pric
fabric1337832fa_bric
iambic12468282iamb_ic
abri65522213_a_bri_
abris75722603_a_bris
acerbic1335653acerbic
acmatic13311703acmatic
acmic11312333acm__ic
agaric93513643_agaric
ambari103012173_ambari_
ambaris113112163_ambaris
ambit94223713_amb_it
ambries111614553_ambries
ambroid1238883_ambroid
ambry123512103_ambr_y
amebic1239113_amebic
amidic114012873_amidic
aminic104413513_aminic
amnic95516243_am_nic
amtrac10109133_amtrac
amylic13108713_amylic
anuric8812113_anuric
auric74521743_a_uric
baldric12166403baldric
barbaric1446383barbaric
baric96125693ba__ric
bawdric15164583bawdric
cabbie122913353ca_bbie
cabin94820943ca_b_in
cadmic1338983ca_dmic
caesuric1244243caesuric
calcic9311873ca_lcic
calorics122810463calorics
calorie92716903calorie
camail10314833cam_ail
camber124418483camb_er
cambered15129003cambered
cambering16109873cambering
cambers134017443cambers
cambial134010763cambial
cambism1538033cambism
cambist13312113cambist
cambium1537323cambium
cambogia1543903cambogia
camelia11510443camelia
camelid1249413camelid
camera10313693camer_a
camerae11312063camerae
cameral11311283cameral
cameras11313363cameras
camisia112810243camisia
cammie124615293cam_mie
camorra11115773camorra
camphoric2045493camphoric
campi116217783cam_pi_
canonic11312933canonic
canopic1338803canopic
cantic103920543ca_ntic
cantrip112910043cantrip
caprice1349683ca_price
capris10415083ca_pris
carbamic1645913carbamic
carbolic1448323carbolic
carbonic1439993carbonic
caseic103212373ca_seic
catbird1235243catbird
catbrier1236183catbrier
caustic1139753caustic
centric11312403centric
cerebric1444643cerebric
ceric94023093c__eric
chambray2043143chambray
chimeric1746743chimeric
chloric143410613chloric
choric133515903c_horic
citric102812313c_itric
cleric10612133c_leric
comatic131816943comatic
comedic14158633comedic
cometic131215723cometic
comic114721813com__ic
coumaric1446183coumaric
cubic114313423c_ub_ic
cumarin1139263cumarin
cumbia12379893cumb_ia
cupric1249123c_upric
daric85623123da__ric
daturic1047043daturic
dimeric12310023dimeric
fabrics1436093fa_brics
fimbria1444453fimbria
fumaric1446313fumaric
gabbroic1541993gabbroic
gambia115912253gamb_ia
gambir11509773gamb_ir
gambirs12359083gambirs
gambit114714213gamb_it
gambrel1235453gambrel
gametic12310003gametic
gamic103916203gam__ic
gastric1038643gastric
homeric14312213homeric
iambi95512223iamb_i_
iambics13425643iamb_ics
iatric8312173ia_tric
lambie103213673lamb_ie
lambkin1545243lambkin
limbic12528743limb_ic
lubric1097983_lubric
mantric11311353mantric
naric76824173na__ric
nombril1145103nombril
numeric1158193numeric
rabic93817403ra_b_ic
rubric1097823_rubric
satiric939263satiric
satyric1237503satyric
scombrid1543373scombrid
tamari8313413tamari_
tamarin9311923tamarin
tamaris9413603tamaris
tambac122210243tamb_ac
tantric939593tantric
tumbril11256403tumbril
valeric1238303valeric
vambrace1743993vambrace
vampiric1742623vampiric

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 Limit1340271316.72019944.5
3Display Results1311310.0304366.7
 (SQL Overall)1786911317.15624970.8
 
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.