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

178 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
serotine831357(None) 
serotines9312071serotines
serotiny1148571serotiny
erotize16311662_erotize
heroine103517492hero_ine
kerosine1238152kerosine
serine65432672ser__ine
serotinal947212serotinal
serotinies1047442serotinies
serotype1345162serotype
sestine73017922se_stine
aerating92821003aerating
aerodyne1244193aerodyne
aerolite8315053aerolite
atropine10410113atropine
berating113220763berating
berline93716853ber_line
beryline1337083beryline
bromine112915243_bromine
carotene1039133carotene
carotin92216733carotin_
carotins102315583carotins
ceratin93020163ceratin_
ceratins102818733ceratins
cerotic11415063ceroti_c
cerotype1544653cerotype
cervine122610803cer_vine
creatine103417413creatine
crocine11314153_crocine
demoting12311423demoting
denoting10311753denoting
denotive1238673denotive
dentine83320243de_ntine
derating103222283derating
destine83719953de_stine
devoting1338823devoting
ecotone938583_ecotone
emetine9712943_emetine
emoting10313563_emoting
emotive1239193_emotive
eosine64519413_e_osine
ermine8416923_er_mine
eroding9314273_eroding
erosive1039203_erosive
erotic82620273_eroti_c
erotica92811513_erotica
erotics91914153_erotics
erotism9312303_erotism
erotized1838563_erotized
erotizes17311213_erotizes
errhine1036593_errhine
escoting1158713escoting
eserine7415903eser__ine
ferine96422583fer__ine
fertile10311733fer_tile
garoting10510703garoting
gelatine93213313gelatine
gratine84719193_gratine
hematine131614673hematine
heroin94420593hero_in_
heroines112916573hero_ines
heroins103518013hero_ins
heroize193210973hero_ize
keratin113314153keratin_
keratins122313483keratins
kerosene1254823kerosene
kerosines1357113kerosines
legatine91311403legatine
leonine7311233le_onine
leporine1049303leporine
meriting11314693meriting
merocrine1346233merocrine
necrotize2046483necrotize
nervine102510633ner_vine
nicotine1058473nicotine
pemoline12310273pemoline
peroxide1848193peroxide
proline92321593_proline
promine112819443_promine
propine113020213_propine
pyronine1349513pyronine
ratine65131823__ratine
rerouting10311873rerouting
retine66237333__retine
revoting12312033revoting
routine72615903__routine
saltine75018563s_altine
saponine1039223saponine
sardine83317393sar_dine
sclerotin1144973sclerotin_
sclerotins1244433sclerotins
scooting113012643scooting
scrutiny1344773scrutiny
searobin1045713searobin_
searobins1145553searobins
seating84130683se_ating
secretin10108343secretin_
secreting1279823secreting
secretins11108463secretins
secretive1446933secretive
sectile9311973se_ctile
sedating103014113sedating
sedative1238853sedative
seedtime1144183seedtime
seine55732873se___ine
semitone1048973semitone
semolina1047493semolina
sentinel838703se_ntinel
sepaline10311343sepaline
septime1138803se_ptime
serein63318463ser_ein_
sereins73716123ser_eins
serene63522353ser__ene
serflike1536273serflike
serging93416673ser_ging
seriating10916403seriating
sericin9312843sericin_
sericins10312463sericins
serin55434443ser__in_
serines74229543ser__ines
sering74731813ser__ing
serins64029673ser__ins
sermonize20148483sermonize
serosae7310253sero_sae
serosity1148793serosity
serotinous1044843serotinous
serotonin947373serotonin
serotonins1046523serotonins
serotyped1543853serotyped
serotypes1445323serotypes
serotyping1643123serotyping
serpentine1246223serpentine
serrating10513213serrating
serrying12167703serrying
service1239093ser_vice
servile10310643ser_vile
serving113014983ser_ving
sestina72711973se_stina
sestines82717243se_stines
setline7313923se_tline
setting83621393se_tting
sextile1438573se_xtile
shooting122812863shooting
shortie10411343shorti_e
shorting122514803shorting
shrine94920053shr__ine
smaltine1037833smaltine
snooting92813203snooting
snorting92613373snorting
sonatine8313323sonatine
sooting82820963s_ooting
sordine82515233sor_dine
soricine10710883soricine
sorptive1346473sorptive
sortie63621993sor_ti_e
sorting83221813sor_ting
sozine15712353s__ozine
spermine12311433sper_mine
sporting112415463sporting
sportive1348333sportive
sprouting1236943sprouting
stotin63215063s_totin_
stotins73213873s_totins
strobile1047033strobile
stroking132610943stroking
strowing122310563strowing
stroying122410593stroying
subroutine1254513subroutine
termtime1244773termtime
terrine72517573ter_rine
tropine93116653_tropine
trotline8310023_trotline
tyrosine1147043tyrosine
veratrine1247753veratrine
versine102515173ver_sine
xerotic16410863xeroti_c
xeroxing1534513xeroxing
zeroing1738343zero_ing

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621787.36019859.0
3Display Results1781780.0762342.1
 (SQL Overall)1786911787.87222699.6
 
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.