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

164 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
serosae731024(None) 
serosa6313021serosa_
serosal7311151serosal
serosas7312661serosas
aerosat7417182aerosat
erose55727272_eros_e
rerose63320842reros_e
serovar1046142serovar
setose65114772setos_e
acerose9310893aceros_e
aerobat9514473aerobat
aerobe8412403aero_be
aerosats8411013aerosats
aerosol747683aerosol
aerospace1343743aerospace
aerostat8410683aerostat
areolae7811733areolae
arose55832083_aros_e
aurorae739663aurorae
brose75227033_bros_e
bursae84515603bur_sae
cerise84822043ceris_e
ceros74726073ceros__
ceruse83914523cerus_e
coronae94214893coronae
crosse85216303_crosse
deposal1037153deposal
depose94215763depos_e
derogate10311353derogate
erase54925493_eras_e
erode64520993_ero_de
eros45238453_eros__
eroses65327053_eroses
erosive1039193_erosive
feriae95618603fer_iae
ferulae10309603ferulae
grosze16457733_grosze
gyrose105310253gyros_e
hermae115314473her_mae
herniae1039043herniae
heroine103517483heroine
heroize193210963heroize
heros84930863heros__
hexosan1744333hexosan
hexose16267843hexos_e
kerosene1254823kerosene
kerosine1238143kerosine
ketose105711813ketos_e
leprose938543lepros_e
medusae1044763medusae
mensae84114053me_nsae
metopae1147743metopae
morose85116243moros_e
mucosae11155313mucosae
necrose939723necros_e
neurosal845833neurosal
operose939433operos_e
peroral9314793peroral
perorate10417923perorate
perse75429523per_s_e
personae102410553personae
perusal939193perusal
peruse84016843perus_e
petrosal1047153petrosal
porose84818743poros_e
prose75835123_pros_e
reposal939113reposal
repose84121413repos_e
rerise64325633reris_e
reroute7313963reroute
rose46148903__ros_e
samosa8510203samosa_
samosas939293samosas
sarode75317513saro_de
saros55238063saros__
saroses73619333saroses
sarsar63011843sar_sar
sclerosal1143163sclerosal
sclerose1046223scleros_e
scoriae9310903scoriae
scrooge1037183scrooge
scrota8310203scrota_
scrotal938493scrotal
scrouge1036353scrouge
seconal9310073seconal
seconde1037413seconde
seesaw935973se_esaw
segos64919483segos__
seise54727853se_is_e
selfsame1342883selfsame
senora63216163senora_
senoras72714953senoras
sensa54117473se_nsa_
sensate7311893se_nsate
sense55526823se_ns_e
sera46141393ser__a_
serac75925203ser__ac
serai56830163ser__ai
seral56336383ser__al
serape84818413ser_ape
serdab937833ser_dab
sere46153473ser___e
serenade9218343serenade
serenate81914883serenate
serene63522353ser_ene
seres55448893seres__
serest64831613seres_t
serfage1138403serfage
serfs84922013serfs__
serge64727473ser__ge
serial64625863ser_ial
seriate73722473seriate
serine65432673ser_ine
serosity1148783serosity
serotine8313573serotine
serotype1345163serotype
serous65023563sero_us
serovars1145233serovars
serow86720443sero__w
serows96016393sero_ws
serrate73017543serrate
sers45746653ser_s__
serumal938783serumal
serval93913413ser_val
serve85425963ser__ve
service1239093service
servile10310643servile
servos93812723servos__
sesame8311013se__same
setae56026223se__tae
shrove125412233shro_ve
sorbose938983sorbos_e
soroche1237183soroche
sororal7310653sororal
sororate8411173sororate
soroses73117483soroses
sorosis72611973sorosis
stoae55024263s_to_ae
striae65422273str_iae
strobe84513813stro_be
strode75215973stro_de
stroke105116173stro_ke
stroma84313073stroma_
stromal93010593stromal
strophe1239143strophe
strove95014793stro_ve
strumae9368093strumae
suberose10109693suberos_e
sucrose939303sucros_e
surbase939793surbase
terrae62915213ter_rae
terse55026823ter_s_e
torose64317693toros_e
uprose82311483upros_e
ursae55214453_ur_sae
venose9310843venos_e
verbose1237753verbos_e
versal93013753ver_sal
verse84723583ver_s_e
verste94515633ver_ste
xerosere1544733xerosere
xeroses143612823xeroses
xerosis14249663xerosis
zeros144918113zeros__

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 Limit1340271646.14021828.5
3Display Results1641640.0463565.2
 (SQL Overall)1786911646.59227107.3
 
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.