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

112 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
diameters124759(None) 
diameter1148051diameter_
dimeters11411091di_meters
biometers1339172biometers
decameters15156592decameters
dekameters17164862dekameters
diabetes1147022diabete_s
diasters92913182dia_sters
dieters83216432di__eters
dimeter10411892di_meter_
dynameters1643792dynameters
agametes1147293agamete_s
ameers84015573__ame_ers
ammeters1237693_ammeters
audiometers1444503audiometers
billeters1136873billeters
bimesters1336343bi_mesters
biometer1239603biometer_
dabsters1137053d_absters
damagers1237063d_amagers
dammers123214273d_am_mers
damners104112113d_am_ners
dampeners1444663d_ampeners
dampers123915693d_am_pers
darters84017603d_a_rters
dasymeters1643593dasymeters
daters74827373d_a__ters
daunters9329853d_aunters
deadeners1146283deadeners
decameter14137363decameter_
decimeters15156683decimeters
deemsters1285023deemsters
dekameter16135103dekameter_
dekametres17133603dekametres
depleters12327543depleters
deters74724683d___eters
diabetics1444663diabetics
diacetyls1542253diacetyls
dialers83614303dia__lers
diallers957773dia_llers
dialogers1155163dialogers
dialysers1343163dialysers
dialyzers2242783dialyzers
diamantes1296263diamante_s
diametral1243803diametral
diametric1446433diametric
diamides1238823diamide_s
diamines11311643diamine_s
diapers104713913dia__pers
diastems11226523dia_stems
diaster82813313dia_ster_
diemakers1645263diemakers
diesters92513603di_esters
dieter73516773di__eter_
diethers1257453di__ethers
digesters11257883digesters
dilaters92513063di_laters
dilatometers1553113dilatometers
diluters9288113di_luters
dimers94321093di_m__ers
dimmers123811563di_m_mers
diopters1137693di_opters
diplexers1943573diplexers
disasters1039153disasters
disinters1039713disinters
dismembers1743773dismembers
disputers1236613disputers
dissenters1197723dissenters
dissevers1386863dissevers
ditherers13196683ditherers
diverters13227873diverters
doomsters1236173doomsters
dosimeters1345113dosimeters
drafters12338523dra_fters
dragsters1134323dragsters
durometers1356373durometers
dynameter1544073dynameter_
dynamiters1642313dynamiters
enamelers1144803enamelers
eudiometers1444143eudiometers
fidgeters1443623fidgeters
gamesters1236733_gamesters
gametes10312253_gamete_s
geometers1238193geometers
hamsters13710423_hamsters
hexameters2244453hexameters
kilometers1686653kilometers
lamenters1137683_lamenters
lamsters1099753_lamsters
limiters10249333li_miters
meters85625833___meters
octameters1444833octameters
odometers1247133odometers
ohmmeters1643783ohmmeters
orometers11310423orometers
oximeters1855143oximeters
parameters1448123parameters
piasters102912813pia_sters
picketers17196483picketers
picometers1648283picometers
radiometers1466173radiometers
rimesters1137483ri_mesters
riveters11228163ri_veters
rotameters1245033rotameters
scamsters1334993scamsters
seamsters1136333seamsters
siameses1036403siamese_s
teamsters1135973teamsters
tiltmeters1244123tiltmeters
trimeters1139213trimeters
udometers1245743udometers
yawmeters1783873yawmeters

Search took 7 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411126.39023261.5
3Display Results1121120.0462434.8
 (SQL Overall)1786911126.85926052.0
 
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.