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 “serpents” 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
serpents10241037(None) 
perpents122312031perpents
serpent92916281serpent_
arpents93613082_arpents
ferments13311472ferments
gerents82612922ger_ents
percents122713362percents
perpends13227732perpends
perpent112318802perpent_
repents93717622re_pents
rerents73319422rer_ents
sarments10311962sarments
segments1138902segments
sequents1756992sequents
serenes73222902ser_enes
sergeants10115592sergeants
serjeants1673962serjeants
servants1137992servants
sorbents10279122sorbents
terpenes102111562terpenes
aperients1178253aperients
argents84014853_argents
arpens84814823_arpen_s
arpent84822093_arpent_
averments1449093averments
berets85822523ber_e_ts
brents84717273_br_ents
carpets113915333carpe_ts
cements112714223ce_ments
cerements13411453cerements
cermets1139713cerme_ts
currents1038373currents
deepens10307813deepen_s
dements103016623de_ments
depends11348993de_pends
descents112511203descents
detents83615153de_tents
eluents738703_eluents
emergents1245973emergents
erects84116183_er_ects
errants7410623_errants
events94814073_e_vents
expects1866883_expects
expends17217083_expends
experts1659063_experts
extents142610173_extents
ferment12315573ferment_
ferrets103111393ferre_ts
fervent13310063fervent_
garments1139963garments
gerent73223093ger_ent_
germens1078623germen_s
herpes115517323herpe__s
margents11410133margents
mordents1138813mordents
orients7311583_orients
parents93418123par_ents
pendents1139413pendents
percent113520593percent_
percepts14247643percepts
perfects15107353perfects
perpend12259333perpen_d
perverts1337523perverts
portents103512823portents
precents123015033precents
presents103315633presents
prevents133012293prevents
reagents959623reagents
regents83416543re_gents
relents74018503re_lents
rents55935183__r_ents
reopens939373reopen_s
reorients997363reorients
repeats94316053re_peats
repent84728873re_pent_
reprints1039903reprints
rerent63832453rer_ent_
rerepeats1145253rerepeats
resents74221223re_sents
respects1247703respects
salients839563salients
sapients1037423sapients
sarcenets1146953sarcenets
sarment9318763sarment_
sarmenta1047723sarmenta
sarsenets946513sarsenets
sarsens7311393sarsen_s
sarsnets836783sarsnets
scents85317023s__cents
screens95212173screen_s
sealants82610743sealants
seaports1038463seaports
seawants11337973seawants
secants93413893se_cants
secrets9311773secre_ts
sediments1248213sediments
segment10312563segment_
seicento1045043seicento
seicentos1144553seicentos
selects91912143se_lects
semens84616963se_men_s
sennets73712583senne_ts
sentients948463sentients
septets998953se_ptets
septs75420603se_p__ts
sequent16410323sequent_
serapes95218103serape__s
sereins73716113ser_eins
serenata8197673ser_enata
serenatas9145183ser_enatas
serenate81914873ser_enate
serene63522353ser_en_e
serener73415753ser_ener
serenest82717623ser_enest
serenity1168963ser_enity
seres55448893ser_e__s
serest64831613ser_est_
sergeant9129403sergeant_
sergeanty13104163sergeanty
sergers83815633serge_rs
serges74225963serge__s
sergings10299203sergings
seriemas1047193seriemas
series64540973serie__s
serines74229543ser_ines
serins64029673ser_in_s
serjeant1596473serjeant_
serjeanty19122723serjeanty
sermons9311783sermon_s
serpentine1246223serpentine
serpentines1355293serpentines
serpigos1143843serpigos
serranos857843serranos
servant10313623servant_
servers103214833serve_rs
serves94423653serve__s
servings12249213servings
sestets7911473seste_ts
sevens93813663se_ven_s
seventh1336773se_venth
sevenths1444793se_venths
seventy1338033se_venty
sexpots1636293sexp_ots
sextants15287383sextants
sextets1497143sexte_ts
sharpens13377813sharpen_s
sherberts1443593sherberts
sherbets1335213sherbe_ts
shipments16254703shipments
silents73514493s_ilents
sippets113310173sippe_ts
sirens65318153sir_en_s
sirvente1145023sirvente
sirventes1244903sirventes
sklents11348163s_klents
solvents1136763solvents
sorbent92915233sorbent_
sorbets93012503sorbe_ts
spelts84614643s__pelts
spends94714473s__pends
spent75532833s__pent_
splents93912133s_plents
sprent84522383spr_ent_
sprints94113773spr_ints
steepens10277113steepen_s
stents65019453s__tents
sterlets8169273sterle_ts
stipends11304793stipends
streets73312613str_eets
strunts7429543str_unts
students954683students
subpenas1246903subpenas
subrents10310293subrents
surfeits1146223surfeits
surprints1145283surprints
suspects1254863suspects
suspends1145143suspends
syrens94911993syr_en_s
tempests1234443tempests
tercets93512443terce_ts
terpene92310853terpen_e
terpenic1247213terpenic
terrenes82212593terrenes
terrets72913573terre_ts
torments10310453torments
torrents838143torrents
varments1339063varments
verbenas1345333verbenas
versants1137783versants
versets103913093verse_ts
vervets13419743verve_ts
wergelts1253413wergelts

Search took 10 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.1561145455.1
2DLD Change Limit1461621928.81316584.8
3Display Results1921920.0762526.3
 (SQL Overall)1786911929.04519755.8
 
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.