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

54 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
cardigans134516(None) 
cardigan1245621cardigan_
cardiacs1376922cardi_acs
cardias10715122cardi_a_s
cardinals1248012cardinals
larrigans1044012larrigans
acaridans1254033acar_idans
artisans888523_artisans
barbicans1544483barbicans
bartisans1165553bartisans
bartizans2053703bartizans
caimans113811783ca__imans
candidas12338653candida_s
caragana1146283car_agana
caraganas1245803car_aganas
caravans1338623car_avans
cardamons1445203cardamons
cardia9916383cardi_a__
cardiac1278823cardi_a_c
cardiae10713713cardi_a_e
cardinal1139573cardina_l
carding113922443cardi__ng
cardings123812643cardi_ngs
cardiograms1753453cardiograms
cardioids1345243cardioids
carditis11310233cardi_tis
cardons104519943card__ons
cardoons113411943card_oons
carinas93622423car_ina_s
caritas93316963car_ita_s
carlins93921923carli__ns
carnivals1444503carnivals
carriages1238333carriages
carrions10312453carri_ons
cordials1139633cordi_als
cordovans1543683cordovans
coreigns1136323coreig_ns
guardians1143913guardi_ans
hardpans1436453hard_pans
harijans1845723har_ijans
harridans13154563harridans
larrigan944213larrigan_
madrigals13856243madrigals
martians103111613marti_ans
marzipans2242643marzipans
origans839973_or_igans
parians93519743par_i_ans
partisans1167493partisans
partizans2055253partizans
ptarmigans1551583ptarmigans
radians83013823ra_di_ans
wanigans1244743wa_nigans
wannigans1342393wannigans
warrigals1343783warrigals

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 Filter1786911486410.436409841.7
2DLD Change Limit148641547.95318689.9
3Display Results54540.0331636.4
 (SQL Overall)178691548.42221217.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.