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

115 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
oestrous86992(None) 
estrous7712531_estrous
oestrus7169581oestr_us
anestrous946602anestrous
bestrows1337042bestrows
desirous947782desirous
destroys1236692destroys
dextrous1646592dextrous
diestrous1046602diestrous
estrus61912112_estr_us
lustrous877802lustrous
monestrous1274282monestrous
monstrous1187342monstrous
oestrins8312672oestrins
oestriols944332oestriols
oestrone849972oestrone
oestrones949772oestrones
oestrum9177782oestr_um
oestrums10156472oestrums
petrous92714422pe_trous
anestrus856313anestr_us
anserous8410543anserous
beshroud1443803beshroud
beshrouds1543063beshrouds
bestows1248863best_ows
bestrews1335603bestrews
bestrode1147133bestrode
bestrow1237243bestro_w
bestrown1345193bestrown
bistros92810983bistro_s
boisterous1244573boisterous
cerous85821203ce__rous
cestos84718093cest_o_s
cestus84412913cest__us
cistrons102710623cistrons
citrous93112993_citrous
decorous1138853decorous
destroy1138153destro_y
dexterous1745553dexterous
diestrus946523diestr_us
dioestrus1043933dioestr_us
elytrous1145503elytrous
escrows1235803_escrows
estops84011223_est_ops
estrays10529403_estrays
estrins7315853_estrins
estriols856253_estriols
estrone7413953_estrone
estrones8313323_estrones
estrum81810513_estr_um
estrums9208603_estrums
fastuous1145143fastuous
ferrous1049793fe_rrous
festoons1136433festoons
feverous1446513feverous
generous939773generous
goitrous945763goitrous
kestrels1235813kestrels
leprous938843le_prous
maestros1046163maestro_s
mesotrons1145513mesotrons
metros84217803me_tro_s
nectarous1144713nectarous
nestors73614973nest_ors
neutrons838293neutrons
nitrous73512483_nitrous
oasthouse1244773oasthouse
ocherous1347013ocherous
ochrous1237943o_chrous
octrois938333o_ctrois
odorous837663o_dorous
oestrin7312243oestr_in
oestriol845373oestriol
oestrogen1044443oestrogen
oestrogens1153463oestrogens
oestruses946403oestruses
olestras846583olestr_as
onerous7312973o_nerous
ordurous944753ordurous
osetras737323osetr_as
osmious936003o_smious
osmous8138183o_s_mous
osseous736053o_sseous
outrows10311403o_utrows
outtrots838373outtrots
pesthouse1445963pesthouse
pestos84719083pest_o_s
petrols92913083pe_trols
pistous92714383pist_ous
polyestrous1652543polyestrous
proestrus1144843proestr_us
resinous838503resinous
resprout1078783resprout
resprouts1174823resprouts
restores85222993restores
restress82511773restress
restroom1047573restroom
restrooms1146033restrooms
restrove1138963restrove
retros63820193re_tro_s
roisterous1044703roisterous
seatrout8411583seatrout
seatrouts946393seatrouts
serous65023563__serous
setous64917373se_t_ous
strops86220383__strops
stroud7310383__stroud
strouds837803__strouds
strows96718273__strows
stroys95914603__stroys
testcross1142543testcross
testons7313553test_ons
testoons837303testoons
venturous1245583venturous
vestries11314053vestries

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.1561145455.1
2DLD Change Limit1461621157.65619091.2
3Display Results1151150.0333484.8
 (SQL Overall)1786911157.84522777.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.