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

166 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
serosal731115(None) 
serosa6313021serosa_
serosae7310241serosae
serosas7312661serosas
aerosat7417182aerosat
aerosol747682aerosol
deposal1037152deposal
neurosal845832neurosal
peroral9314792peroral
perusal939192perusal
petrosal1047152petrosal
reposal939112reposal
sclerosal1143162sclerosal
scrotal938492scrotal
seconal9310072seconal
seral56336382ser__al
serial64625862ser_ial
serovar1046142serovar
serumal938782serumal
serval93913412ser_val
sororal7310652sororal
stromal93010592stromal
versal93013752ver_sal
aerial64625713aer_ial
aerobat9514473aerobat
aerogel836523aerogel
aerosats8411013aerosats
aerosols847213aerosols
aerostat8410683aerostat
arousal748633_arousal
auroral7310473auroral
berascal1244853berascal
bromal10313653_bromal
bursal84414823bur_sal
carousal1056283carousal
ceramal1138843ceramal
cercal10314123cer_cal
cereal8315833cer_eal
ceros74726073ceros__
coronal94115763coronal
creosol946053creosol
deposals1145443deposals
dermal93614343der_mal
devisal1136913devisal
dorsal74613943dor_sal
eros45238453_eros__
erose55727273_eros_e
erosely1038083_erosely
eroses65327053_eroses
espousal1083013espousal
exposal1645313exposal
femoral1238723femoral
feral85424653fer__al
ferial94621253fer_ial
girosol885303girosol
herbal112513493her_bal
hernial10310433hernial
heroical13410023heroical
heros84930863heros__
hexosan1744333hexosan
medusal1035183medusal
mensal84615663me_nsal
mucosal11155843mucosal
nerol51017813nero__l
neuronal846893neuronal
pedocal1237893pedocal
peroneal1049173peroneal
persalt9315413per_salt
personal102311573personal
perusals1047143perusals
phrasal1246163phrasal
preoral9312673preoral
rearousal943493rearousal
recoal84117973reco_al
recusal968673recusal
refusal1056893refusal
regosol844883regosol
removal1236733removal
reposals1037413reposals
reprisal1045903reprisal
reproval1355773reproval
reroll6412683rero_ll
rerose63320843reros_e
retotal739843retotal
revisal1038263revisal
royal85014703__royal
samosa8510203samosa_
samosas939303samosas
saros55238063saros__
saroses73619333saroses
sarsar63011843sar_sar
scribal1137963scribal
scroll8310173scro_ll
scrota8310203scrota_
seal45654373se___al
seasonal847263seasonal
seconals1047053seconals
sectoral10109543sectoral
seesaw935973se_esaw
segetal868383segetal
segos64919483segos__
seismal937303seismal
seminal91213413seminal
semioval1346223semioval
sendal73314993se_ndal
senora63216163senora_
senoras72714953senoras
sensa54117473se_nsa_
sensual738053sensual
sepal77723003se__pal
septal84513383se_ptal
sera46141393ser__a_
serac75925203ser__ac
serai56830163ser__ai
serail64222673ser_ail
serdab937833ser_dab
seres55448893seres__
serest64831613seres_t
serfs84922013serfs__
serials73919753ser_ials
serosity1148783serosity
serotinal947213serotinal
serous65023563sero_us
serovars1145233serovars
serow86720443sero__w
serows96016393sero_ws
sers45746653ser_s__
servals103410753ser_vals
servos93812723servos__
setal56430903se__tal
setose65114773setos_e
several1039533several
sexual1338423se_xual
shoal83920273s_ho_al
sisal54217733s__isal
skoal93811463s_ko_al
soroses73117493soroses
sorosis72611973sorosis
sponsal946343sponsal
sporal82915453s_poral
spousal965533spousal
sterical10311253sterical
sternal73411913ster_nal
steroidal1045473steroidal
sterol6613333stero__l
stomal85213313s_tomal
stratal72710603stratal
strobil936963strobil
stroll6311603stro_ll
stroma84313073stroma_
suboral92011993suboral
suboval12216723suboval
sudoral8148543sudoral
supposal1244913supposal
sural55931263sur__al
surreal739233surreal
surroyal1143953surroyal
synodal1145743synodal
tarsal63315273tar_sal
tergal72912833ter_gal
tertial7313863tertial
verbal112513663ver_bal
vernal93514213ver_nal
xeroses143612823xeroses
xerosis14249663xerosis
zeros144918113zeros__

Search took 8 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 Limit1340271667.40618097.1
3Display Results1661660.0463608.7
 (SQL Overall)1786911667.85822740.0
 
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.