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

213 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
sarsnet731481(None) 
sarsenet8412941sarsenet
sarsnets836781sarsnets
baronet91022202baronet
carnet84732872car_net
garnet73928412gar_net
harslet10315652harslet
sarcenet10413312sarcenet
sarment9318762sarment
sarsen6314232sars_en
sarsenets946512sarsenets
sarsens7311392sarsens
satinet7325282satinet
absent84016993_absent
ardent73022613_ardent
arene55329413_arene_
arenes64928393_arenes
argent74023663_argent
armet76739453_ar_met
armlet84118193_armlet
arpent84822093_arpent
arse46539273_ars_e_
arseno6318913_arseno
arses55733873_ars_es
arsine64021043_arsine_
arsines73518813_arsines
assent65119953_assent
asset55932263_a_sset
bannet84925333ba_nnet
barbet104427883bar_bet
barned95623583bar_ned
barney115314453bar_ney
baronets101410903baronets
barret84930483bar_ret
basinet9318933basinet
basket125722913ba_sket
basset85225383ba_sset
bassinet10312843bassinet
bayonet121212213bayonet
brunet84419293_brunet
burnet84326173bur_net
cabinet11318903cabinet
carcanet12316343carcanet
caret75360563car__et
carnets93918403car_nets
carney115315703car_ney
carpet104530093car_pet
carse74934333cars_e_
carses85233653cars_es
casket124820993ca_sket
clarinet10317293clarinet
cornet84436733cor_net
coronet94227173coronet
corset85636223cors_et
corslet9318063corslet
darned85018483dar_ned
darnel74312183dar_nel
darner74017303dar_ner
dragnet91211433dragnet
earned74818333ear_ned
earner63617223ear_ner
earnest7318733ear_nest
earshot10410823earshot
gannet74321853ga_nnet
garget84327273gar_get
garment10315233garment
garner73917003gar_ner
garnets84115403gar_nets
garret74426553gar_ret
gasket114417253ga_sket
gurnet74920873gur_net
hairnet10911703hairnet
hardset113415833hardset
harshen1339283harshen
harsher13310363harsher
harshest14310193harshest
harslets1137833harslets
haslet93222713ha_slet
hornet94926433hor_net
jaconet16311483jaconet
karst97228993kars__t
larine63927043larine_
magnet9320663ma_gnet
margent10316693margent
marine84230403marine_
mariner93315993mariner
marines93928013marines
market123226043mar_ket
marse76231153mars_e_
marses84827113mars_es
marshes123615373marshes
martinet10319643martinet
martlet93419153martlet
narine63422553narine_
oarsmen938093oarsmen
parapet11317643parapet
pardner10239473pardner
parent83230423paren_t
parget94529393par_get
parquet18311583parquet
parse75236993pars_e_
parsec105914473pars_ec
parsed96323893pars_ed
parser84822373pars_er
parses85534703pars_es
parsley1247793parsley
parsnip1146323parsnip
partlet92720363partlet
partner92811393partner
sabine84020383sabine_
sabines94318483sabines
sachet114725773sa_chet
sained75424243sa_ined
saint55147073sa_in_t
salient7419763salient
saline65132703saline_
salines74029413salines
sallet63734543sa_llet
samlet84126563sa_mlet
sane45954333sa__ne_
saned65636273sa__ned
saner54334323sa__ner
sanes55649073sa__nes
sanest64426693sa__nest
sansei63411903sans_ei
sapient9415333sapient
saran53730303saran__
sarans64224433saran_s
sarape84817573sarape_
sarapes94617743sarapes
sarcenets1146953sarcenets
sardine83317393sardine_
sardined10268663sardined
sardines92815563sardines
saree55044663sar__ee
sarees65329943sar_ees
sarge65531133sar_ge_
sarges75128593sar_ges
sarin55239253sarin__
sarins63932623sarin_s
sarkier113413313sarkier
sarkiest123615063sarkiest
sarmenta1047723sarmenta
sarments10311963sarments
sarode75317513sarode_
sarodes84216143sarodes
sarong73914873saron_g
sarongs84511803sarongs
saroses73619333saroses
sarsar63011843sars_ar
sarsars73512143sarsars
sashed105622943sa_shed
sashes94728483sa_shes
sassed76116173sa_ssed
sasses64124393sa_sses
sassier73413233sassier
sassies74719263sassies
sassiest83413613sassiest
satinets8311733satinets
savant9416043savan_t
savine94220283savine_
savines104417633savines
sawney12387603sa_wney
sayst85322003says__t
scarlet91516943scar_let
sennet64224143s_ennet
serene63522353serene_
serener73415753serener
serenes73222903serenes
serenest82717623serenest
serine65432673serine_
serines74229543serines
serpent92916283serpent
sestet6826203s_estet
shrine94920053shrine_
shrined114112413shrined
shrines104618693shrines
signet73621153s_ignet
sonnet65923503s_onnet
sorbent92915233sorbent
sorbet83924073sor_bet
sorned74820043sor_ned
sorner64720383sor_ner
sparklet143110583sparklet
sparse84516343spars_e_
sparser94311483spars_er
sparsest1048813sparsest
spinet85629753s_pinet
sprent84522383spren_t
sprint84526793sprin_t
starlet71620123star_let
street64125773str_eet
strunt64918913strun_t
subnet82520933s_ubnet
subset83122583subs_et
sunset63723633suns_et
target75028903tar_get
tarsier74119253tarsier
tartlet72218483tartlet
tasset65925313ta_sset
varlet9423503var_let
varment12313243varment
verset94327323vers_et
wadset10314303wads_et
warned104018913war_ned
warner93717223war_ner
warsle93112923warsle_
warsled112910443warsled
warsler10289893warsler
warsles103413643warsles
worset96726583wors_et
yarned105514023yar_ned
yarner93313063yar_ner

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340272138.11016526.1
3Display Results2132130.0932290.3
 (SQL Overall)1786912138.34321418.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.