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

272 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
silvern1034714(None) 
silver93815811silver_
silvers104714041silvers
silvery13328091silvery
saltern74010652saltern
salver94617752salver_
salvers103916002salvers
sievert10613292sievert
silken104410852silke_n
siller64026062siller_
sillers73822102sillers
silvan92810152silv_an
silvered12237562silvered
silverer11216732silverer
silvering1337922silvering
silverly14284312silverly
silvex16336722silve_x
siver85728612si_ver_
sivers95324152si_vers
sliver94116592sliver_
slivers104115252slivers
solver94016702solver_
solvers104414252solvers
wivern12409282wi_vern
aileron739833ail_eron
aiver85725163ai_ver_
aivers94822323ai_vers
bilker124913443bilker_
bilkers134711863bilkers
biller84923483biller_
billers94720833billers
bittern94810683bittern
cavern115312453_cavern
cistern93310703cistern
cithern12489913cithern
cittern9339143cittern
clivers123411753clivers
culver113010633culver_
culverin1345173culverin
culvers12329833culvers
culvert123011773culvert
delver104913493delver_
delvers113411993delvers
desilver12286503desilver_
desilvers13306083desilvers
discern1038493discern
diver94827803di_ver_
divers105024963di_vers
divert103922813di_vert
elver85216243_elver_
elvers93814983_elvers
filbert12411643filbert
filer85433003fil_er_
filers94623723fil_ers
filler94623623filler_
fillers104320213fillers
filmer114112403filmer_
filmers124211293filmers
filter94517633filter_
filters103816553filters
fiver116024943fi_ver_
fivers124420923fi_vers
gilbert10310763gilbert
gilder84415533gilder_
gilders94212463gilders
giller74519733giller_
gillers84216903gillers
gittern8337503gittern
given95915283gi_ve_n
giver94921203gi_ver_
givers104817713gi_vers
govern1036823_govern
halvers133311423halvers
hiller94421633hiller_
hillers103718733hillers
iller54821293_iller_
intern64016543_intern
invert94120083_invert
jilter133512513jilter_
jilters144211963jilters
jiver155119053ji_ver_
jivers164515643ji_vers
killer104917953killer_
killers114215583killers
kilter103714343kilter_
kilters113813603kilters
klavern1433003klavern
liever94611863liever_
liven85021733li_ve_n
liver85132963li_ver_
livers94927823li_vers
livery124910903li_very
milden94113153milde_n
milder93818453milder_
miler75733063mil_er_
milers84625163mil_ers
milker124814323milker_
milkers134411613milkers
miller84625413miller_
millers93621343millers
milter84921233milter_
milters93619093milters
oiler54628283oil_er_
oilers64721193oil_ers
oilier64417233oilier_
oilmen848313oilme_n
pilfer1139163pilfer_
pilfers1238963pilfers
resilver11337503resilver_
resilvers12306503resilvers
riever94811653riever_
rievers104311453rievers
riven85121623ri_ve_n
river85731693ri_ver_
rivers94626543ri_vers
sailer63526103sail_er_
sailers73822323sail_ers
salter64325083salter_
salterns8388903salterns
salters73622253salters
salve85022133salve__
salved103916423salve_d
salves94221763salve_s
salvor94711093salvor_
salvors103910913salvors
saver84831253s_aver_
savers93825923s_avers
sclera838893scl_era
secern81010223s_ecern
seller63824593seller_
sellers73721313sellers
selves94119613selve_s
server94917713server_
servers103214833servers
seven84118313s_eve_n
sever85426053s_ever_
severe94016083s_evere
severs94121123s_evers
shaven124213303shave_n
shaver123718913shaver_
shavers134115093shavers
shelver134211063shelver_
shelvers14388813shelvers
shiver124517373shiver_
shivers133714833shivers
shivery16317023shivery
shover124515993shover_
shovers134613003shovers
sicken124615253sicke_n
sicker124023903sicker_
sidler74716963sidler_
sidlers83414233sidlers
sieve84918843sieve__
sieved104611443sieve_d
sieverts1145713sieverts
sieves93216003sieve_s
sifter94516233sifter_
sifters103714793sifters
sigher103813703sigher_
sighers113712183sighers
signer74015633signer_
signers84714443signers
siker95326033si_ker_
sileni63312143sil_eni
silent64125843sil_ent
silex123417413sil_e_x
silicon9117533silicon
silked114314813silke_d
silkier114411643silkier_
sillier74017593sillier_
siloed74615303siloe_d
silted74020013silte_d
siltier73413863siltier_
silva82714023silv__a
silvae92811093silv_ae
silvans10308333silvans
silvas92912183silv_as
silverers12215753silverers
silverings1443843silverings
silvexes1843633silvexes
silvics1235563silvics
simmer104115353simmer_
simmers113314613simmers
simper103616293simper_
simpers113014123simpers
sincere9310553sincere
singer74227313singer_
singers83824703singers
sinker103620903sinker_
sinkers113618543sinkers
sinner64320603sinner_
sinners74019023sinners
sinter63625923sinter_
sinters74024083sinters
sipper103920993sipper_
sippers113117753sippers
siren54525823si_re_n
sister64421583sister_
sisters73721593sisters
sitten64113823sitte_n
sitter63323383sitter_
sitters74221553sitters
sixteen1434113sixteen
sizer145521813si_zer_
sizers155215813si_zers
sizier1514813393sizier_
skiver134612103skiver_
skivers14409703skivers
slaver94419613slaver_
slavers103716503slavers
slavery13407893slavery
slicer84117603slicer_
slicers94114923slicers
slider73918363slider_
sliders83515223sliders
slier54827243s_lier_
slivered12218103slivered
sliverer11237633sliverer
slivering1338083slivering
sloven9389633slove_n
slyer85515123s_lyer_
smiler83916683smil_er_
smilers94113853smil_ers
soever94412093soever_
solder73921343solder_
solders83517773solders
solemn838643sol_emn
solve85618943solve__
solved105312933solve_d
solvent10310833solvent
solves95018223solve_s
spiller92914333spiller_
spillers103311703spillers
spleen8310263spl_een
stern55319123s__tern
stiller73414293stiller_
stiver93915733stiver_
stivers103613543stivers
stover94115643stover_
stovers103713733stovers
suaver93014233suaver_
subvert12312893subvert
sulker104015923sulker_
sulkers113613343sulkers
sullen62914293sulle_n
sweven1235983sweve_n
swiller103211663swiller_
swillers11299113swillers
sylvan12257363sylv_an
sylvin12247303sylv_in
tavern9428933_tavern
tiler56131023til_er_
tilers63523503til_ers
tiller64222543tiller_
tillers73418743tillers
tilter63417693tilter_
tilters73315953tilters
viler86324163vil_er_
villein1036753villein
vivers124717363vi_vers
wilder103616473wilder_
wilders113513503wilders
wilier93217073wilier_
willer94021063willer_
willers103517913willers
wiver115924513wi_ver_
wiverns13366963wi_verns
wivers125320803wi_vers
wolver12419713wolver_
wolvers13349313wolvers
wyvern15363923_wyvern
zithern19447023zithern

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272725.92022639.7
3Display Results2722720.0932924.7
 (SQL Overall)1786912726.41927837.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.