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

192 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
sarsnets83678(None) 
sarsenets946511sarsenets
sarsnet7314811sarsnet_
baronets101410902baronets
carnets93918402car_nets
garnets84115402gar_nets
harslets1137832harslets
sarcenets1146952sarcenets
sarments10311962sarments
sarsenet8412942sarsenet_
sarsens7311392sars_ens
satinets8311732satinets
absents93510723_absents
arenes64928393_arene_s
argents84014853_argents
armets84918353_ar_mets
armlets94610063_armlets
arpents93613083_arpents
arses55733873_ars_e_s
arsines73518813_arsine_s
assents74512223_assents
assets65617663_a_ssets
bannets94013843ba_nnets
barbets114915843bar_bets
bareness10912813bareness
barneys12569563bar_neys
baroness101210063baroness
baronet91022203baronet_
barrets94917103bar_rets
basinets1039063basinets
baskets135111833ba_skets
bassets96414823ba_ssets
bassinets1146323bassinets
bassness1096743bassness
bayonets13135583bayonets
brunets9419553_brunets
burnets93813263bur_nets
cabinets1238283cabinets
carcanets1347303carcanets
carets85330773car__ets
carnet84732873car_net_
carneys124310543car_neys
carpets113915333car_pets
carses85233653cars_e_s
caskets133910173ca_skets
clarinets1137683clarinets
cornets94820573cor_nets
coronets103814363coronets
corsets94819803cors_ets
corslets1038273corslets
darkness13247343darkness
darnels83710433dar_nels
darners83815773dar_ners
dragnets10136563dragnets
earners74016453ear_ners
earnest7318733ear_nest
earnests837853ear_nests
earshots1146623earshots
farness102912203far_ness
gannets83811443ga_nnets
gargets94614573gar_gets
garments1139963garments
garners83815983gar_ners
garnet73928413gar_net_
garrets84413623gar_rets
gaskets12348153ga_skets
gurnets84010793gur_nets
hairnets1195633hairnets
hardness122411083hardness
harness102413933har_ness
harshens1437603harshens
harshest14310193harshest
harshness1545963harshness
harslet10315653harslet_
haslets102510863ha_slets
hornets104113553hor_nets
jaconets1745613jaconets
karsts106012943kars__ts
magnets10311143ma_gnets
margents11410133margents
mariners103113863mariners
marines93928013marine_s
markets133314033mar_kets
marses84827113mars_e_s
marshes123615373marshe_s
martinets1138883martinets
martlets103310483martlets
parapets1239763parapets
pardners11269193pardners
parents93418123paren_ts
pargets105215193par_gets
parquets1936413parquets
parsecs11429923pars_ecs
parsers94118153pars_ers
parses85534703pars_e_s
parsleys1335083parsleys
parsnips1245533parsnips
partlets102811513partlets
partners102711133partners
rareness81112853rareness
sabines94318483sabine_s
sachets123914103sa_chets
sadness8310613sa_dness
safeness11239633safeness
sageness92111983sageness
saints65122423sa_in_ts
salients839563salients
salines74029413saline_s
sallets73719653sa_llets
saltness82610243saltness
sameness102712683sameness
samlets93813553sa_mlets
saneness82313723saneness
sanes55649073sa__ne_s
sanest64426693sa__nest
sanseis73011603sans_eis
sapients1037423sapients
sarans64224433saran__s
sarapes94617743sarape_s
sarcenet10413313sarcenet_
sardines92815563sardine_s
sarees65329943sar__ees
sarges75128593sar_ge_s
sarins63932623sarin__s
sarkiest123615063sarkiest
sarment9318763sarment_
sarmenta1047723sarmenta
sarodes84216143sarode_s
sarongs84511803saron_gs
saroses73619333sarose_s
sarsars73512143sars_ars
sarsen6314233sars_e_n
sashes94728483sa_she_s
sasses64124393sa_sse_s
sassies74719263sassie_s
sassiest83413613sassiest
sassiness8249333sassiness
satinet7325283satinet_
savants1038653savan_ts
savines104417633savine_s
sawneys13274643sa_wneys
scariness11310183scariness
scarlets10178573scar_lets
sennets73712583s_ennets
serenes73222903serene_s
serenest82717623serenest
serines74229543serine_s
serpents102410373serpents
sestets7911473s_estets
sharpness1434933sharpness
shrines104618693shrine_s
signets83311503s_ignets
smartness1136143smartness
solonets838233solonets
sonnets74211993s_onnets
sorbents10279133sorbents
sorbets93012513sor_bets
soreness8914793soreness
sorners73416873sor_ners
spareness1139863spareness
sparklets15275843sparklets
sparseness1245493sparseness
sparsest1048813spars_est
spinets94714813s_pinets
sprints94113773sprin_ts
spryness1334003spryness
starets73515923star__ets
starkness1335963starkness
starlets81610083star_lets
streets73312613str_eets
strunts7429543strun_ts
subnets92512083s_ubnets
subsets92813103subs_ets
sunsets72911573suns_ets
sureness8912903sureness
swartness1236113swartness
targets84314223tar_gets
tarsiers8298533tarsiers
tartlets8289663tartlets
tartness82210133tartness
tassets75012773ta_ssets
varlets10411573var_lets
varments1339063varments
versets103913103vers_ets
wadsets1136443wads_ets
wariness11313213wariness
warmness1337063warmness
warners103315563war_ners
warslers11328073warslers
warsles103413643warsle_s
worsets105512843wors_ets
yarners104312203yar_ners

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621927.78318779.6
3Display Results1921920.0603200.0
 (SQL Overall)1786911928.27921583.6
 
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.