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
cardigans134515(None) 
cardigan1245611cardigan_
cardiacs1376912cardi_acs
cardias10715112cardi_a_s
cardinals1247992cardinals
larrigans1044012larrigans
acaridans1254033acar_idans
artisans888523_artisans
barbicans1544483barbicans
bartisans1165553bartisans
bartizans2053703bartizans
caimans113811783ca__imans
candidas12338643candida_s
caragana1146283car_agana
caraganas1245793car_aganas
caravans1338623car_avans
cardamons1445203cardamons
cardia9916373cardi_a__
cardiac1278813cardi_a_c
cardiae10713703cardi_a_e
cardinal1139563cardina_l
carding113922433cardi__ng
cardings123812633cardi_ngs
cardiograms1753453cardiograms
cardioids1345223cardioids
carditis11310223cardi_tis
cardons104519933card__ons
cardoons113411943card_oons
carinas93622403car_ina_s
caritas93316953car_ita_s
carlins93921913carli__ns
carnivals1444493carnivals
carriages1238333carriages
carrions10312453carri_ons
cordials1139623cordi_als
cordovans1543683cordovans
coreigns1136323coreig_ns
guardians1143913guardi_ans
hardpans1436453hard_pans
harijans1845723har_ijans
harridans13154563harridans
larrigan944213larrigan_
madrigals13856233madrigals
martians103111613marti_ans
marzipans2242643marzipans
origans839973_or_igans
parians93519733par_i_ans
partisans1167483partisans
partizans2055243partizans
ptarmigans1551583ptarmigans
radians83013823ra_di_ans
wanigans1244743wa_nigans
wannigans1342393wannigans
warrigals1343773warrigals

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.440406115.9
2DLD Change Limit148641547.54619698.0
3Display Results54540.0301800.0
 (SQL Overall)178691548.01622291.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.