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

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

60 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
alkalimetries1910184(None) 
alkalimeter1792003alkalimet__er
alkalimeters1891753alkalimet_ers
alkalimetry2061603alkalimetr__y
alkalinities1653003alkalinit_ies
allometries1386953al__lometries
altimetries1355923al__timetries
salimetries1345693__salimetries
acidimetries1752754a_cidimetries
algometries14105904al__gometries
alkalifies1743234alkali___fies
alkalizers23153954alkalize_r__s
calorimetries1752544cal_orimetries
fluorimetries1862334fluorimetries
gravimetries1852484_gravimetries
polarimetries17102404polarimetries
actinometries1754105actinometries
aerometries1348395a__erometries
alkalies12158545alkal_____ies
alkalified1852645alkali___fied
alkalinizes24142885alkali__nizes
alkalises13167485alkali____ses
alkalizer22155565alkalize_r___
alkalizes22157355alkali____zes
allometric1446895al__lometri_c
allopatries1354335al__lopatries
allosteries1155395al__losteries
analities9715875a_nali__t_ies
anemometries1654165a_nemometries
astrometries1455515a_strometries
asymmetries1853935a__symmetries
audiometries1554145a_udiometries
auralities10410225aurali__t_ies
axialities1747735axiali__t_ies
axisymmetries2761695axisymmetries
barometries1547695__barometries
cabinetries1544085__cabinetries
cephalometries2363015cephalometries
colorimetries1752845colorimetries
coulometries1654655_coulometries
craniometries1753415_craniometries
dekalitres1542965dekali__tr_es
dekametres17133605deka__metr_es
dilatometries1663135dilatometries
dosimetries1454755__dosimetries
dynamometries2162185dynamometries
fallaleries1453115fallal__e_ries
fluorometries1863055fluorometries
glazieries2043575gl_azi_e_ries
kilometres16115785__kilometr_es
latimerias1253695_l_atime_rias
lavalieres1352235lavali_e_r_es
manometries1547255__manometries
maumetries1446025__ma_umetries
oximetries1944565___oximetries
palmistries1593765__palmistries
perimetries1547785__perimetries
planimetric1753675pl_animetri_c
radiometries1575885__radiometries
telemetries1355585__telemetries

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 Filter1786911247900.390458182.1
2DLD Change Limit124790608.28015071.3
3Display Results60600.0331818.2
 (SQL Overall)178691608.70320532.1
 
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.