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

121 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
pigments133734(None) 
figments1446941figments
pigment12510731pigment_
ailments1039432ailments
augments1137832augments
figment1379742figment_
fitments1376792fitments
ligaments1246202ligaments
payments1536942payments
piglets103311792pigle_ts
pigmented1544062pigmented
pigpens1235502pigpen_s
pimento1157222pi_mento
pimentos1246232pi_mentos
repigments1546342repigments
segments1138902segments
agents74816293_ag_ents
aiglets84012913aigle_ts
aigrets82810533aigre_ts
ailment9314233ailment_
alignments1344633alignments
aliments10311093aliments
aments85219803__aments
argents84014853arg_ents
arguments1256573arguments
augment10910203augment_
bailments1346463bailments
cements112714223_cements
comments142913883comments
dements103016623_dements
digests93610613dig_ests
diluents946053diluents
dissents93411863dissents
elements10312173elements
ferments13311473ferments
filaments1446653filaments
fitment12710303fitment_
foments122912053_foments
fragments1546213fragments
garments1139963garments
gents65729613__g_ents
giglets93211553gigle_ts
hutments1345603hutments
incents92414533_incents
indents83114663_indents
intents72115703_intents
invents102812053_invents
judgments2043253judgments
kismets13306883kisme_ts
laments94314853_laments
ligament1149313ligament_
limens84618033li_men_s
liniments1146613liniments
lodgments1344183lodgments
loments93413473_loments
migrants1138183migrants
mismeets12297733mismeets
moments113113123_moments
oddments1244103oddments
ointments1166653ointments
orpiments1346003orpi_ments
pageants1136693pageants
paraments13511553paraments
parents93418123p_arents
patents94815203p_atents
patients1088763patients
pavements1647003pavements
payment14310703payment_
pediments1448343pediments
pelmets11309693pelme_ts
pendents1139413pendents
percents122713373percents
perpents122312043perpents
pickets154314183picke_ts
piedmonts1442803piedmonts
pigboats1344523pigboats
pigeons1039183pig_eons
piggins113010473piggin_s
piglet93420923pigle_t_
pigmentary1852953pigmentary
pigmenting1653713pigmenting
pigmies122610993pigm_ies
pignus937953pig__nus
pignuts1035613pig_nuts
pigouts1037593pig_outs
pigpen1136583pigpen__
pigsneys1442003pigsneys
pigweeds1553143pigweeds
pimiento1243253pimiento
pimientos1342833pimientos
pinenes93416673pi_nenes
pinkens13419643pinken_s
pints75936223pi___nts
piolets93513193piole_ts
pipets105714773pi_pe_ts
piquets1836603pique_ts
pissants1097363pissants
pitmans11188743pitman_s
pitmen102510793pitmen__
portents103512823portents
precents123015043precents
presents103315643presents
prevents133012293prevents
pschents1544113pschents
raiments1039903raiments
regents83416543reg_ents
regiments123910323regiments
repigment1447923repigment_
sarments10311963sarments
segment10312563segment_
shipments16254703shipments
siemens938413siemen_s
signets83311503signe_ts
silents73514493si_lents
tegmenta1155613tegmenta
teguments1265453teguments
torments10310453torments
unguents945153unguents
varments1339063varments
wiglets113411423wigle_ts
wisents10249063wi_sents

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.423422437.4
2DLD Change Limit1461621217.10620568.8
3Display Results1211210.0502420.0
 (SQL Overall)1786911217.57923577.1
 
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.