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 “cambrics” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
cambrics164525(None) 
cambric1537381cambric_
ambries111614552_ambries
calorics122810462calorics
fabrics1436092fa_brics
iambics13425642iamb_ics
abris75722603_a_bri_s
agarics10319943_agarics
ambaries123312383_ambaries
ambaris113112163_ambari_s
amberies122514683_amberies
ambits103713413_amb_its
ambroids1346503_ambroids
amtracs1198883_amtracs
baldrics13164893baldrics
bawdrics16153273bawdrics
cabbies133115163ca_bbies
cabins104418923ca_b_ins
caloric113413223caloric_
calories102919553calories
camails11311753cam_ails
cambering16109873cambering
cambers134017443camb_ers
cambia124913153camb_i_a
cambial134010763camb_ial
cambism1538033camb_ism
cambisms1645803cambisms
cambist13312113camb_ist
cambists1437023cambists
cambium1537323camb_ium
cambiums1644933cambiums
cambogias1643853cambogias
camelias12510303camelias
camelids1356943camelids
cameras11313363camer_as
camisias12268603camisias
cammies134016483cam_mies
camorras12116503camorras
canaries10318943canaries
cantrips12318933cantrips
capric12411803ca_pric_
caprice1349683ca_price
caprices1439893ca_prices
capris10415083ca_pri_s
carbolics1546723carbolics
carices114220953ca__rices
caries85147623ca__ries
carries94328013ca_rries
catbirds1344203catbirds
catbrier1236173catbrier
catbriers1344143catbriers
caustics1237483caustics
chambrays2142423chambrays
clerics1149333c_lerics
comics124015563com__ics
cubics123810163c_ub_ics
cumarins1238643cumarins
cumbias13338963cumb_ias
cumbrous1446173cumbrous
darics94314113da__rics
daubries1136743daubries
fabric1337833fa_bric_
gambias125010733gamb_ias
gambirs12359083gamb_irs
gambits12399723gamb_its
gambrels1334213gambrels
iambic12468283iamb_ic_
lambies113015113lamb_ies
lambkins1664983lambkins
nombrils1244513nombrils
numerics1266283numerics
rubrics1177093_rubrics
scombrids1642333scombrids
tamarins10310843tamarins
tamaris9413593tamari_s
tambacs13219363tamb_acs
tumbrils12255373tumbrils
vambrace1743983vambrace
vambraces1843773vambraces

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 Filter1786911461620.403443402.0
2DLD Change Limit146162796.90621164.5
3Display Results79790.0332393.9
 (SQL Overall)178691797.34224338.2
 
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.