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

107 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
paraments1351155(None) 
parament12415391parament_
paramenta1368861paramenta
apartments1445702apartments
armaments1347472_armaments
garments1139972gar_ments
parakeets1545102parakeets
paramounts1443892paramounts
parapets1239762parape_ts
parchments1944982parchments
parents93418122par__ents
parliaments1553572parliaments
pavements1647002pavements
payments1536942pa_yments
sacraments1445852sacraments
sarments10311962sar_ments
varments1339062var_ments
adamants1186343_adamants
ailments1039433_ailments
aliments10311093_aliments
aments85219803___aments
apartment1347033apartment_
arames84622573_arame__s
argents84014853_ar_gents
arguments1256573_arguments
armament1249633_armament_
armets84918353_ar_me_ts
arpents93613083_ar_pents
augments1137833_augments
bailments1346463bailments
basements1348263basements
calamints1348053calamints
caramels1238803carame_ls
casements1348583casements
cerements13411453cerements
departments1645793departments
duramens1195153duramen_s
easements11410333easements
ferments13311473fer_ments
filaments1446653filaments
firmaments1744293firmaments
foramens1337823foramen_s
fragments1546213fragments
garment10315233gar_ment_
harassments1653433harassments
hardiments1644533hardiments
impartments1745353impartments
laments94314853__laments
ligaments1246203ligaments
margents11410133mar_gents
ornaments1146633ornaments
paraders113113113parade_rs
parades104121463parade__s
paragons11311503paragon_s
parakeet14410523parakeet_
paramagnets1653673paramagnets
paramatta1345313paramatta
paramattas1454363paramattas
paramecia1545933paramecia
paramedic1645723paramedic
paramedics1744153paramedics
parameter1349123parameter
parameters1448123parameters
paramos113213513param__os
paramount1347183paramount_
paramours1345653paramours
parangs104314373para__ngs
parapet11317643parape_t_
paraquats2044383paraquats
paraquets2044593paraquets
parasangs1246033parasangs
paravanes1448303paravanes
parawings1535823parawings
parchment1846913parchment_
parent83230423par__ent_
pargets105215193par_ge_ts
parliament1454653parliament_
parquets1936413parque_ts
parrakeets1652363parrakeets
partlets102811513partle_ts
parvenus1335653par_venus
patents94815203p__atents
patients1088763pa_tients
pavement1549443pavement_
payment14310703pa_yment_
pediments1448343pediments
percents122713373per_cents
permanents1455453permanents
perpents122312043per_pents
pigments1337343p_igments
placements1645973placements
portamenti1454203portamenti
portamento1463793portamento
portents103512823por_tents
precents123015043p_recents
presents103315643p_resents
prevents133012293p_revents
raiments1039903ra_iments
ramenta9311183__ramenta
ramets83517393__rame_ts
rearmaments1554263rearmaments
sacrament1347943sacrament_
sarment9318763sar_ment_
sarmenta1047723sar_menta
torments10310453tor_ments
varment12313243var_ment_
varmints1335643var_mints

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.423422437.4
2DLD Change Limit1486411077.32620289.5
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.79522923.8
 
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.