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

93 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
sarcenet1041331(None) 
sarcenets1146951sarcenets
sarsenet8412941sarsenet
carcanet12316342carcanet
larcener1036492larcener
parcener1238472parcener
sarment9318762sarmen_t
sarsenets946512sarsenets
sarsnet7314812sar_snet
accent105116263_accen_t
arcane81216743_arcane_
ardent73022613_arden_t
arene55329413_ar_ene_
arenes64928393_ar_enes
argent74023663_argen_t
arpent84822093_arpen_t
ascent84519653_ascen_t
baronet91022203bar_onet
barrener1038333barrener
barrenest1149563barrenest
bracelet12310693bracelet
carcanets1347303carcanets
careened1139193careened
careener1039323careener
carnet84732873car__net
darkened1435943darkened
darkener1335993darkener
falconet13410353falconet
gardened1137003gardened
gardener1037103gardener
garment10315233garmen_t
garnet73928413gar__net
hardened1338613hardened
hardener1238883hardener
harkened1637483harkened
harkener1537573harkener
jaconet16311483ja_conet
lancelet1049473lancelet
larceners1135993larceners
larcenies1147533larcenies
larcenist1147323larcenist
larceny1234853larcen_y
margent10316693margen_t
martinet10319643martinet
narceine1046753narceine_
narceines1146583narceines
nascent9610523nascen_t
parceled1338343parceled
parceners1337453parceners
parent83230423par_en_t
percent113520603percen_t
sachet114725773sa_c_het
saddened1135343saddened
salient7419763salien_t
sapient9415333sapien_t
sarcina9310733sarcin_a
sarcinae1047193sarcinae
sarcinas1039273sarcinas
sardine83317393sardine_
sardined10268663sardined
sardines92815563sardines
saree55044663sar_e_e_
sarees65329943sar_e_es
sarmenta1047723sarmenta
sarments10311963sarments
sarsen6314233sarsen__
sarsens7311393sarsen_s
sarsnets836783sar_snets
satinet7325283sa_tinet
saucepot1243943saucepot
scarceness1444763scarceness
scarcest12169173scarce_st
scene77220573s__cene_
scenes84520353s__cenes
scent75831623s__cen_t
screened1137413screened
screener1037573screener
serene63522353ser_ene_
serener73415763ser_ener
serenes73222903ser_enes
serenest82717623ser_enest
serpent92916283serpen_t
sharpened1544483sharpened
sharpener1444583sharpener
sirvente1145023sirvente
smartened1244263smartened
sorbent92915243sorben_t
sorcerer1036433sorcerer
sprent84522383spr_en_t
street64125773str_e_et
tercelet1049883tercelet
varment12313243varmen_t
warrener1136913warrener

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.546327272.9
2DLD Change Limit146162937.11020557.2
3Display Results93930.0303100.0
 (SQL Overall)178691937.68623248.9
 
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.