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

125 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
diameter114805(None) 
diameters1247581diameters
dimeter10411891di_meter
biometer1239602biometer
decameter14137362decameter
dekameter16135102dekameter
diabetes1147022diabetes
diaster82813312dia_ster
dieter73516772di__eter
dimeters11411082di_meters
dynameter1544072dynameter
agamete1037393agamete_
agametes1147293agametes
ameer75618983__ame_er
ammeter1148393_ammeter
audiometer1344823audiometer
billeter1037563billeter
bimester1236163bi_mester
biometers1339153biometers
dabster1036703d_abster
dafter104813343d_a_fter
damager1157973d_amager
dammer114317933d_am_mer
damneder1243763d_amneder
damner95213433d_am_ner
dampener1335533d_ampener
damper114117753d_am_per
darter75320363d_a_rter
dasymeter1553503dasymeter
dater65332313d_a__ter
daunter83811753d_aunter
deadener1036743deadener
decameters15156593decameters
decimeter14147413decimeter
deemster1175713deemster
dekameters17164863dekameters
dekametre16133583dekametre
depleter11298853depleter
deter65028043d___eter
diabetic1346543diabetic
diacetyl1452913diacetyl
diademed1344153diademed
dialer74315433dia__ler
dialler848813dia_ller
dialoger1056083dialoger
dialyser1243693dialyser
dialyzer2143113dialyzer
diamante1186413diamante_
diamantes1296263diamantes
diametral1243803diametral
diametric1446413diametric
diamide1138473diamide_
diamides1238813diamides
diamine10311973diamine_
diamines11311623diamines
diaper94513113dia__per
diapered1238003diapered
diastem10318043dia_stem
diasters92913173dia_sters
diemaker1545593diemaker
diester83013683di_ester
dieted83115493di__eted
dieters83216423di__eters
diether1147443di__ether
digester10258423digester
dilater83515643di_later
dilatometer1453263dilatometer
diluter8319653di_luter
dimer85625603di_m__er
dimmer114112613di_m_mer
diopter1038473di_opter
diplexer1844203diplexer
directer1137583directer
disaster949943disaster
disinter9310673disinter
dismaler1137903dismaler
dismember1643983dismember
disputer1137973disputer
dissenter1059133dissenter
dissever12107653dissever
ditherer12187763ditherer
diverter12238623diverter
doomster1135843doomster
dosimeter1245363dosimeter
drafter11449423dra_fter
dragster1034623dragster
durometer1246443durometer
dynameters1643793dynameters
dynamiter1542953dynamiter
enameler1045883enameler
eudiometer1344163eudiometer
fidgeter1343783fidgeter
gamester1137323_gamester
gamete9313593_gamete_
gametes10312253_gametes
geometer1138423geometer
hamster12810423_hamster
hexameter2144853hexameter
kilometer1576933kilometer
lamenter1038863_lamenter
lamster9109913_lamster
limiter92710853li_miter
meter75130323___meter
octameter1355013octameter
odometer1147413odometer
ohmmeter1543613ohmmeter
orometer10310703orometer
oximeter1755153oximeter
parameter1349123parameter
piaster93012883pia_ster
picketer16187433picketer
picometer1548913picometer
radiometer1366423radiometer
rimester1037813ri_mester
riveter10208753ri_veter
rotameter1145443rotameter
scamster1235303scamster
seamster1037143seamster
siamese936503siamese_
siameses1036403siameses
teamster1036293teamster
tiltmeter1144343tiltmeter
trimeter10310083trimeter
udometer1146333udometer
yawmeter1693873yawmeter

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621257.42319690.4
3Display Results1251250.0801562.5
 (SQL Overall)1786911257.67323288.3
 
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.