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
diameters124758(None) 
diameter1148051diameter_
dimeters11411081di_meters
biometers1339152biometers
decameters15156592decameters
dekameters17164862dekameters
diabetes1147022diabete_s
diasters92913172dia_sters
dieters83216422di__eters
dimeter10411892di_meter_
dynameters1643792dynameters
agametes1147293agamete_s
ameers84015573__ame_ers
ammeters1237693_ammeters
audiometers1444493audiometers
billeters1136863billeters
bimesters1336323bi_mesters
biometer1239603biometer_
dabsters1137053d_absters
damagers1237063d_amagers
dammers123214273d_am_mers
damners104112113d_am_ners
dampeners1444663d_ampeners
dampers123915693d_am_pers
darters84017603d_a_rters
dasymeters1643593dasymeters
daters74827363d_a__ters
daunters9329843d_aunters
deadeners1146283deadeners
decameter14137363decameter_
decimeters15156673decimeters
deemsters1285023deemsters
dekameter16135103dekameter_
dekametres17133603dekametres
depleters12327533depleters
deters74724683d___eters
diabetics1444663diabetics
diacetyls1542253diacetyls
dialers83614293dia__lers
diallers957773dia_llers
dialogers1155163dialogers
dialysers1343163dialysers
dialyzers2242783dialyzers
diamantes1296263diamante_s
diametral1243803diametral
diametric1446413diametric
diamides1238813diamide_s
diamines11311623diamine_s
diapers104713893dia__pers
diastems11226523dia_stems
diaster82813313dia_ster_
diemakers1645253diemakers
diesters92513593di_esters
dieter73516773di__eter_
diethers1257453di__ethers
digesters11257873digesters
dilaters92513053di_laters
dilatometers1553113dilatometers
diluters9288103di_luters
dimers94321093di_m__ers
dimmers123811563di_m_mers
diopters1137683di_opters
diplexers1943563diplexers
disasters1039143disasters
disinters1039703disinters
dismembers1743773dismembers
disputers1236603disputers
dissenters1197723dissenters
dissevers1386863dissevers
ditherers13196683ditherers
diverters13227863diverters
doomsters1236163doomsters
dosimeters1345113dosimeters
drafters12338523dra_fters
dragsters1134323dragsters
durometers1356363durometers
dynameter1544073dynameter_
dynamiters1642313dynamiters
enamelers1144803enamelers
eudiometers1444133eudiometers
fidgeters1443613fidgeters
gamesters1236733_gamesters
gametes10312253_gamete_s
geometers1238183geometers
hamsters13710423_hamsters
hexameters2244443hexameters
kilometers1686643kilometers
lamenters1137683_lamenters
lamsters1099753_lamsters
limiters10249323li_miters
meters85625833___meters
octameters1444833octameters
odometers1247133odometers
ohmmeters1643783ohmmeters
orometers11310403orometers
oximeters1855143oximeters
parameters1448113parameters
piasters102912803pia_sters
picketers17196473picketers
picometers1648273picometers
radiometers1466163radiometers
rimesters1137473ri_mesters
riveters11228153ri_veters
rotameters1245033rotameters
scamsters1334983scamsters
seamsters1136323seamsters
siameses1036403siamese_s
teamsters1135973teamsters
tiltmeters1244123tiltmeters
trimeters1139203trimeters
udometers1245743udometers
yawmeters1783873yawmeters

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411127.07621006.4
3Display Results1121120.0631777.8
 (SQL Overall)1786911127.31224438.0
 
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.