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 “oestrum” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
oestrum917778(None) 
estrum81810511_estrum
oestrums10156471oestrums
oestrus7169581oestrus
centrum1168602centrum
diestrum1145362diestrum
estrums9208602_estrums
estrus61912112_estrus
lustrum945852lustrum
nostrum946952nostrum
oestrin7312242oestrin
oestrous869922oestrous
ostium8310132o_stium
rostrum947212rostrum
sistrum946562sistrum
strum75619452__strum
anestrus856313anestrus
antrum8611313_antrum
asarum84610913_asarum
bestrew1248003bestrew
bestrid1039973bestrid
bestrow1237253bestrow
bestud9439303best_ud
centrums1236913centrums
centum104012363cent_um
cesium1039583ces_ium
cestus84412913cest_us
chetrum1445343chetrum
colostrum13133713colostrum
construe1049053construe
decorum1246943decorum
destroy1138153destroy
destruct1148383destruct
diestrums1244413diestrums
diestrus946523diestrus
dioestrus1043933dioestrus
electrum1245213electrum
elytrum1243563elytrum
esteem838813_esteem
estral64716513_estral
estray95713333_estray
estrin6315923_estrin
estrous7712533_estrous
estrual7367933_estrual
ferrum1147453fe_rrum
gesture839243gesture
jestful1745333jestful
kestrel1137113kestrel
lustrums1044663lustrums
menstrua1044023menstrua
menstruum1352673menstruum
mentum104511713ment_um
nostrums1045683nostrums
obstruct1246033obstruct
oestrins8312673oestrins
oestriol845383oestriol
oestrone849973oestrone
oestruses946403oestruses
olestra746173olestr_a
olestras846583olestras
omentum1155933oment_um
onstream1045113onstream
osetra667423osetr_a
osetras737323osetras
osmium1036573o_smium
outrun63213303o_utrun
outswum1244563outswum
outtrump1243373outtrump
overtrim1337483overtrim
overtrump1643563overtrump
plastrum1245713plastrum
plectrum1453953plectrum
proestrus1144843proestrus
rectum103411283rect_um
restful1038623restful
restroom1047573restroom
restruck1445223restruck
restrung9176443restrung
retrim83514883re_trim
rostrums1046083rostrums
scrum95418203__scrum
septum1038003sept_um
serum75223473__serum
sistrums1055313sistrums
spectrum1444073spectrum
struma84313273__struma
strums84716453__strums
strut56030733__strut
stum65526023__st_um
tantrum946683tantrum
tectum10328603tect_um
veratrum1344313veratrum
vestral104111013vestral
vestry1238623vestr_y
vesture10310373vesture
zestful1945243zestful

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.390458182.1
2DLD Change Limit134027966.79619721.5
3Display Results96960.0462087.0
 (SQL Overall)178691967.23224708.4
 
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.