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

126 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
serumal93878(None) 
brumal1049502_brumal
ceramal1138842ceramal
dermal93614342der_mal
perusal939192perusal
seismal937302seismal
seral56336382ser__al
serial64625862ser_ial
serosal7311152serosal
serum75223472serum__
serums83916302serum_s
serval93913412ser_val
sexual1338412sexu_al
stromal93010592stromal
struma84313272struma_
strumae9368092strumae
strumas9419832strumas
aerial64625713aer_ial
asexual1443973asexu_al
bromal10313653_bromal
brutal859383_brutal
ceramals1246513ceramals
cercal10314123cer_cal
cereal8315833cer_eal
cerumen1147763cerumen
crural8610633_crural
decimal1238083decimal
decuman1236573decuman
derma84918513der_ma_
dermas94116813der_mas
equal1449823_equ_al
estrual7367933estru_al
feral85424653fer__al
ferial94621253fer_ial
ferula93011173ferula_
ferulae10309603ferulae
ferulas103110753ferulas
feudal1037683fe_udal
formal113215203for_mal
frugal1036393_frugal
german9611983ger_man
hemal104419803he__mal
herbal112513493her_bal
herdman13238423herdman
herma105318883her_ma_
hermae115314473her_mae
hermai118912863her_mai
hernial10310433hernial
jejunal1342833jejunal
medusal1035183medusal
merman10513863mer_man
neural6311993ne_ural
normal83213533nor_mal
peroral9314793peroral
perusals1047143perusals
primal104014623_primal
ramal74622243__ramal
recusal968673recusal
refusal1056893refusal
refutal1046943refutal
rugal65916093__rugal
rural55821173__rural
scribal1137963scribal
scrotal938493scrotal
scrum95418203scrum__
scrums104614253scrum_s
seal45654373se___al
seaman84015903se_aman
sebum93814553sebum__
sebums10369813sebum_s
seconal9310073seconal
secular92211533secular
sedum84115573sedum__
sedums93910483sedum_s
seedman1037373seedman
segetal868383segetal
semimat11412913semimat
seminal91213413seminal
semirural1144023semirural
sendal73314993se_ndal
sensual738053sensual
sepal77723003se__pal
septal84513383se_ptal
sequel1556713sequ_el
sequela1663993sequela
sera46141393ser__a_
serac75925203ser__ac
serai56830163ser__ai
serail64222673ser_ail
serdab937833ser_dab
serials73919743ser_ials
seriema938403seriema_
seriemas1047193seriemas
sermon8413553ser_mon
serosa6313023serosa_
serosae7310243serosae
serosas7312663serosas
serovar1046143serovar
servals103410743ser_vals
setal56430903se__tal
several1039533several
sevruga1142223sevruga_
sevrugas1242153sevrugas
sororal7310653sororal
spousal965533spousal
squeal1538023s_queal
sterical10311253sterical
sternal73411913ster_nal
stigmal10245923stigmal
stomal85213313s_tomal
stratal72710603stratal
stroma84313073stroma_
strudel835783strudel
strum75619453strum__
strums84716453strum_s
sumac99514883s__umac
sural55931263s__ural
surfman1236203surfman
surreal739233surreal
sutural7310223sutural
tergal72912833ter_gal
tertial7313863tertial
thermal125010973ther_mal
verbal112513663ver_bal
vernal93514213ver_nal
versal93013753ver_sal

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.420425454.8
2DLD Change Limit1340271266.69020033.9
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.15624970.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.