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 “elaterin” 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
elaterin84990(None) 
elaterid948611elaterid
elaterins9410031elaterins
elater64724202elater__
elaterids1046162elaterids
elaterite949722elaterite
elaterium1146352elaterium
elaters74420192elater_s
altering91917113al_tering
bacterin12410273bacterin
blathering16107583blathering
blattering13108713blattering
cateran9313773_cateran
catering112019903_catering
clattering13109233clattering
clavering1538373clavering
cratering12312653cratering
dewatering1545773dewatering
eastern74412533easter_n
eaten55323053e_ate__n
eater54639843e_ater__
eateries8324313e_ateries
eaters65535953e_ater_s
eatery95316353e_ater_y
eglatere945153eglater_e
eglateres1044443eglateres
elain55324703ela___in
elastin72611843ela_stin
elate55335883elate___
elated74725823elate__d
elatedly1244783elatedly
elaterites1048273elaterites
elateriums1244333elateriums
elates65032363elate__s
elating83423083elat__ing
elation73620453elat_ion
elytron1045463elyt_ron
enteric9314213e_nteric
entering91920053e_ntering
enteron7313333e_nteron
esoteric1057593esoteric
estrin6315923e_st_rin
exoteric1746803exoteric
extern1348473e_xter_n
faltering132211113faltering
flanerie1146913flanerie
flaperon13124843flaperon
flatiron1144623flatiron
flattering1498743flattering
gelatin83514733gelat__in
glutelin944083glutelin
glutenin944033glutenin
glycerin1444353glycerin
haltering132212003haltering
hematein1387013hemate_in
klavern1433003klaver_n
lagering102212313_lagering
lantern7310013_lanter_n
lateen64014863_late_en
laten54328343_late__n
latening9711493_latening
later54843923_later__
laterad8310843_laterad
lateral7313573_lateral
laterite8716333_laterite
laterize17613293_laterize
lathering13912253_lathering
latria62313593_lat_ria
latrine7715123_lat_rine
lattin64316223_lat_tin
layering122310353_layering
leathering1488683leathering
leathern11398913leather_n
lectern937033lecter_n
lettering102112073lettering
lutein6311263_lute_in
melatonin1146343melatonin
paltering122612893paltering
peltering122011673pel_tering
plastering1339243plastering
platen84518203plate__n
plater84427693plater__
platers93924093plater_s
pterin81014153__pterin
realtering1139473realtering
relater73723143relater__
relaters83218153relater_s
saltern74010653salter_n
slater64429183slater__
slaters73123733slater_s
slathering14108283slathering
slattern837093slatter_n
slavering1338723slavering
veratrin1147703verat_rin
watering122316313_watering
weltering13219493wel_tering

Search took 9 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.1531167915.0
2DLD Change Limit146162967.81318707.5
3Display Results96960.0332909.1
 (SQL Overall)178691967.99922339.2
 
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.