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

137 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
sarcasm113669(None) 
sarcasms1244981sarcasms
barcas101016602barcas_
carcase11312732carcase
carcass11310512carcass
narcism1188732narcism
arcade91013643_arcade
arcana8912583_arcana
arcane81216743_arcane
arcanum1176443_arcanum
archaism1547103_archaism
arcs67834783_arc_s_
arcus76918863_arcus_
areas55935773_areas_
arecas84817443_arecas_
arias55438023_arias_
arras55626133_arras_
barca91319433barca__
cacas95627983ca_cas_
carcases12313083carcases
cardcase1345963cardcase
carwash1535993carwash
fantasm1236593fantasm
farces115223323farces_
fascism1436443fascism
fracas11311993fracas_
gearcase1154453gearcase
harass9313943har_ass
hardass1139753hardass
hardcase1445623hardcase
karmas123013733karmas_
laicism1138243laicism
larvas9310233larvas_
maracas11313773maracas_
maras75443293mar_as_
marcato1139743marcato
marcs95726623marc_s_
markas124717003markas_
marram10313883marra_m
marrams11310123marrams
narcisms1267263narcisms
narcist9512443narcist
narcos86714203narcos_
narcose95910383narcose
narcs76122023narc_s_
orcas75918623_orcas_
orgasm966303_orgasm
pacas96029403pa_cas_
paras76143043par_as_
parecism1458533parecism
parkas125018023parkas_
racism103214193ra_cism
sabras85116363sabras_
saccade12107033saccade
saccate111311763saccate
sachem134012223sa_chem
sacks114228873sa_cks_
sacra74516993sacra__
sacral83414413sacra_l
sacrals93311793sacrals
sacrist9315423sacrist
sacrum103910143sa_crum
sacrums11388043sacrums
sacs65739073sa_c_s_
sadism94113493sa_dism
sagas66025883sa_gas_
saices84221803saices_
saigas74114293saigas_
salaam8711013sa_laam
salaams997703salaams
salpas85116923salpas_
salsas65316133salsas_
sambas104219263sambas_
sanctum1145293sanctum
sangas75222653sangas_
saran53730303sar_a_n
sarans64224433sar_ans
sarape84817573sar_ape
sarcastic1365693sarcastic
sarcina9310733sarcina
sarcinas1039273sarcinas_
sarcoid10310453sarcoid
sarcoma1147403sarcoma
sarcomas1247223sarcomas_
sarcoplasm16142893sarcoplasm
sarcosome1344393sarcosome
sarcous9312933sarcous
sardana838643sardana
sardar73013173sarda_r
sardars83112903sardars
sards64736183sar_ds_
sarees65329943sarees_
sargasso942253sargasso
sargassum1251583sargassum
sarges75128593sarges_
sargos74318273sargos_
sarins63932623sarins_
saris54544953sar_is_
sarks96632463sar_ks_
sarods74918573sarods_
saros55238063sar_os_
sarsar63011843sarsa_r
sarsars73512143sarsars
sauces84919503sauces_
sauchs115112233sauchs_
saunas63915433saunas_
scam85932353s__ca_m
scams94423973s__cams
scarcest12169173scarcest
scram910621623scr_a_m
scrams105216623scr_ams
scream104814253screa_m
screams114810623screams
seracs84418573seracs_
sharias102516003sharias_
sirras63814863sirras_
smartass1044273smartass
smearcase1342533smearcase
socas74026183s_ocas_
soras55041013sor_as_
spasm94514173s__pasm
spicas104715823spicas_
staircase1143213staircase
strass67117223str_ass
stream84717293strea_m
streams94713373streams
sucrase9310343sucrase
suras55336333sur_as_
surbase939793surbase
surcease1086883surcease
surpass938283surpass
surras65919533surras_
tsarism958253tsar_ism
varas86028193var_as_
varias95019903varias_
varnas94212823varnas_
yardarm13114533yardarm

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.390458182.1
2DLD Change Limit1340271377.04619021.7
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.48223882.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.