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

84 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
sarsenet841294(None) 
sarcenet10413311sarcenet
sarsenets946511sarsenets
sarsnet7314811sars_net
sarcenets1146952sarcenets
sarment9318762sarmen_t
sarsen6314232sarsen__
sarsens7311392sarsen_s
sarsnets836782sars_nets
absent84016993_absen_t
ardent73022613_arden_t
arene55329413_ar_ene_
arenes64928393_ar_enes
argent74023663_argen_t
arpent84822093_arpen_t
arsenal739383_arsenal
arsenate81010483_arsenate
arsenic939323_arsenic
arsenite8119663_arsenite
arseno6318913_arsen_o
arsine64021043_arsine_
arsines73518813_arsines
assent65119953_assen_t
baronet91022203bar_onet
barrener1038333barrener
barrenest1149563barrenest
basinet9318933ba_sinet
bassinet10312843bassinet
carcanet12316343carcanet
careened1139193careened
careener1039323careener
carnet84732873car__net
cassene93111543cassene_
cassenes103611293cassenes
coarsened1245143coarsened
corselet10414573corselet
darkened1435943darkened
darkener1335993darkener
gardened1137003gardened
gardener1037103gardener
garment10315233garmen_t
garnet73928413gar__net
hardened1338613hardened
hardener1238883hardener
harkened1637483harkened
harkener1537573harkener
harshened1644453harshened
harslet10315653hars_let
hoarsened1344053hoarsened
larcener1036493larcener
margent10316693margen_t
martinet10319643martinet
parcener1238473parcener
parent83230423par_en_t
saddened1135343saddened
salient7419763salien_t
sapient9415333sapien_t
sardine83317393sardine_
sardined10268663sardined
sardines92815563sardines
saree55044663sar_e_e_
sarees65329943sar_e_es
sarmenta1047723sarmenta
sarments10311963sarments
satinet7325283sa_tinet
screened1137403screened
screener1037563screener
serene63522353ser_ene_
serener73415753ser_ener
serenes73222903ser_enes
serenest82717623ser_enest
serpent92916283serpen_t
sharpened1544483sharpened
sharpener1444583sharpener
sirvente1145023sirvente
smartened1244263smartened
sorbent92915243sorben_t
sparseness1245493sparseness
sparsest1048813sparse_st
sprent84522383spr_en_t
street64125773str_e_et
varment12313243varmen_t
warrener1136913warrener
worsened1236053worsened

Search took 7 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.186960704.3
2DLD Change Limit146162846.73621698.6
3Display Results84840.0302800.0
 (SQL Overall)178691846.95225703.5
 
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.