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

183 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
stromal9301059(None) 
stomal85213311st_omal
stroma84313071stroma_
bromal10313652_bromal
scrotal938492scrotal
serosal7311152serosal
serumal938782serumal
sororal7310652sororal
stigmal10245922stigmal
stoma75918272st_oma_
stomas84816322st_omas
stratal72710602stratal
strobil936962strobil
stroll6311602stro_ll
stromata1047592stromata
struma84313272struma_
strumae9368092strumae
strumas9419832strumas
acromial1248463acromial
aroma71220153_aroma_
aromas81018623_aromas
astragal945623astragal
astral66919283astr__al
atonal6514023at_onal
atrial65418943atr_ial
auroral7310473auroral
bromals1139743_bromals
brumal1049503_brumal
ceramal1138843ceramal
chroma132912473chroma_
chromas142512693chromas
chromyl17275233chromyl
comal95125133__comal
coronal94115763coronal
dermal93614353der_mal
domal85619203__domal
estral64716513estr__al
estrual7367933estr_ual
formal113215213for_mal
matronal1048113matronal
normal83213543nor_mal
osteoma945433osteoma_
osteomas1045333osteomas
ottoman946283ottoman
patronal1048653patronal
peroral9314793peroral
petrosal1047153petrosal
primal104014623_primal
ramal74622253__ramal
roman75424823__roman
royal85014703__royal
sarcoma1147403sarcoma_
sarcomas1247223sarcomas
scribal1137963scribal
scroll8310173scro_ll
scrota8310203scrota_
seconal9310073seconal
seismal937303seismal
seral56336383ser__al
serial64625863ser_ial
serosa6313023serosa_
serosae7310253serosae
serosas7312663serosas
serovar1046143serovar
serval93913413ser_val
shoal83920273s_ho_al
skoal93811463s_ko_al
soma65635293s__oma_
soman75024903s__oman
somas76030373s__omas
sporal82915453s_poral
stammel11607533stammel
statal61613223st_atal
steal56125473st__eal
stemma10328133stemma_
stemmas11256973stemmas
sterical10311253sterical
sternal73411913sternal
steroidal1045483steroidal
sterol6613333stero__l
stibial946583stibial
stigma9226763stigma_
stigmas10206643stigmas
stoa45425913st_o_a_
stoae55024263st_o_ae
stoai55417873st_o_ai
stoas55126023st_o_as
stoat57135953st_o_at
stoical9310283stoical
stomach1436033st_omach
stomata938533st_omata
stomatal1045833st_omatal
stomate9313123st_omate
stomp95616663st_om_p
stomps105612833st_omps
stool55619893st_o_ol
storax1389783st_orax
storm76520403storm__
stormed1039043stormed
stormily1345243stormily
storms85814633storm_s
stormy115510733storm_y
stramash1344573stramash
strap77925263str__ap
strata63616283strata_
stratas73013583stratas
straw813321293str__aw
stray88525573str__ay
streak104613623str_eak
stream84717293str_eam
streams94713373streams
streamy12509483streamy
streel64214023str_eel
stria55723213str_ia_
striae65422273str_iae
strigil837263strigil
strobe84513813stro_be
strobes93813263strobes
strobic1138253strobic
strobila1044933strobila
strobile1047033strobile
strobili1044933strobili
strobils1046563strobils
strode75215973stro_de
stroke105116173stro_ke
stroked124613623stroked
stroker114113523stroker
strokes114316323strokes
strolls739183strolls
stromatic13410213stromatic
strong74914883stro_ng
strongly1245953strongly
strongman1243743strongman
strongyl1243553strongyl
strook10410303stro_ok
strop77422243stro__p
strophe1239143strophe
stroppy14205093stroppy
strops86220383stro_ps
stroud7310383stro_ud
strouds837803strouds
strove95014793stro_ve
strow88920573stro__w
strowed115312143strowed
strown96812093stro_wn
strows96718273stro_ws
stroy87720393stro__y
stroyed114110863stroyed
stroyer103510783stroyer
stroys95914603stro_ys
strudel835783strudel
strum75619453strum__
strums84716453strum_s
suboral92011993suboral
suboval12216723suboval
sudoral8148543sudoral
sural55931263sur__al
surfman1236203surfman
surreal739233surreal
surroyal1143953surroyal
synodal1145743synodal
tamal73522633_t_amal
toman75724053_t_oman
tombal102311023_t_ombal
tonal53724303_t_onal
total55321823_t_otal
tramel84113713_tramel
trial54926353_tr_ial
tribal8611133_tribal
trinal6516963_trinal
troak95213573_tro_ak
trocar848773_trocar
trochal1288243_trochal
troll54416533_tro_ll
trommel11315363_trommel
tromp95815803_trom_p
trompe105611263_trompe
tromps104911703_tromps
trona54118953_trona_
tronas63816903_tronas
trotyl9236673_trotyl
trowel94211463_trowel
tryma1037223_tryma_

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 Limit1340271836.28021341.9
3Display Results1831830.0632904.8
 (SQL Overall)1786911836.74926476.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.