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

135 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
parament1241539(None) 
paramenta1368861paramenta
paraments13511551paraments
apartment1347032apartment
armament1249632_armament
garment10315232gar_ment
parakeet14410522parakeet
paramount1347182paramount
parapet11317642parape_t
parchment1846912parchment
parent83230422par__ent
parliament1454652parliament
pavement1549442pavement
payment14310702pa_yment
sacrament1347942sacrament
sarment9318762sar_ment
varment12313242var_ment
adamant101110443_adamant
ailment9314233_ailment
aliment9316703_aliment
ament76036543___ament
apartments1445703apartments
apparent1248263apparent
arame75026623_arame__
arames84622573_arame_s
ardent73022613_ar_dent
argent74023663_ar_gent
argument1158903_argument
armaments1347473_armaments
armet76739453_ar_me_t
arpent84822093_ar_pent
augment10910203_augment
bailment1249183bailment
barmen105418533bar_men_
basement12311493basement
calamint12315133calamint
caramel11310253carame_l
caramels1238803caramels
carmen104019343car_men_
casement12311953casement
cerement12315133cerement
department1546813department
diriment11410743diriment
duramen1096903duramen_
duramens1195153duramens
easement10414163easement
ferment12315573fer_ment
filament13410033filament
firmament1645403firmament
foramen12310533foramen_
foramens1337823foramens
fragment1448373fragment
garments1139963gar_ments
harassment1554553harassment
hardiment1546063hardiment
impartment1646493impartment
lament85024943__lament
ligament1149313ligament
margent10316693mar_gent
oarsmen938093oarsmen_
ornament1049133ornament
packmen1746313packmen_
parade94720643parade__
paraded114014263parade_d
parader103914863parade_r
paraders113113113paraders
parades104121463parade_s
parading12313863parading
parae76335703para_e__
paragon10311023paragon_
paragons11311503paragons
parakeets1545103parakeets
paramagnet1555743paramagnet
paramatta1345313paramatta
paramecia1545933paramecia
paramedic1645723paramedic
parameter1349123parameter
paramo102614643param__o
paramos113213513param_os
paramounts1443893paramounts
paramour1246083paramour
parang93715513para__ng
parapets1239763parapets
paraquat1947613paraquat
paraquet1948783paraquet
parasang1147333parasang
parashot13410143parashot
paravane1348103paravane
parawing14310583parawing
parchments1944983parchments
parents93418123par__ents
parget94529393par_ge_t
parliaments1553573parliaments
parquet18311583parque_t
parrakeet1545603parrakeet
partaken1445553partaken_
partlet92720363partle_t
parvenu1247023par_venu
patent84524923p__atent
patient9617073pa_tient
patulent1048603patulent
pavements1647003pavements
payments1536943pa_yments
pediment13411393pediment
percent113520603per_cent
permanent1368783permanent
permeant12310913per_meant
perpent112318813per_pent
pigment12510733p_igment
placement1548183placement
portamenti1454203portamenti
portamento1463793portamento
portent93619643por_tent
precent113520263p_recent
premeet11615153p_remeet
premen105017803p_remen_
present94022733p_resent
prevent124016553p_revent
prudent10310433p_rudent
purulent1047613purulent
putamen1135923putamen_
raiment9315413ra_iment
ramen75625193__ramen_
ramenta9311183__ramenta
ramet75743143__rame_t
rearmament1455383rearmament
sacraments1445853sacraments
sagamen10127503sagamen_
sarmenta1047723sar_menta
sarments10311963sar_ments
torment9316173tor_ment
varments1339063var_ments
varmint12311683var_mint
warmest123113033war_mest
yardmen1335423yardmen_

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.420425454.8
2DLD Change Limit1461621357.22020244.0
3Display Results1351350.0462934.8
 (SQL Overall)1786911357.68623248.9
 
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.