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

178 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
pigment1251073(None) 
figment1379741figment
pigments1337341pigments
ailment9314232ailment
augment10910202augment
figments1446942figments
fitment12710302fitment
ligament1149302ligament
payment14310702payment
piglet93420922pigle_t
pigmented1544062pigmented
pigpen1136582pigpen_
pigpens1235502pigpens
pimento1157222pi_mento
pitmen102510792pitmen_
repigment1447922repigment
segment10312562segment
agent65829643_ag_ent
aidmen92610373aidmen_
aiglet74224193aigle_t
aigret73720023aigre_t
ailments1039433ailments
airmen82612353airmen_
alignment1246373alignment
aliment9316703aliment
ament76036543__ament
argent74023663arg_ent
argument1158903argument
augments1137833augments
bagmen115412533bagmen_
bailment1249183bailment
bigfeet1376153bigfeet
biggest1138143biggest
cement103321663_cement
clement11313773clement
cogent9321003cog_ent
comment1310317703comment
dement93825143_dement
digest84019623dig_est
diluent8310263diluent
dimmest1249253dimmest
diriment11410743diriment
dissent84018683dissent
distent84120853distent
element9317803element
epigene1037893epig_ene
exigent1539513exig_ent
ferment12315573ferment
filament13410033filament
firmest1239273firmest
fitments1376793fitments
foment113718303_foment
fragment1448373fragment
gagmen103910413gagmen_
garment10315233garment
gent56954393__g_ent
giglet83920273gigle_t
highest1439563highest
hitmen11239193hitmen_
hutment1239173hutment
incent83320723_incent
indent73021243_indent
intent63122773_intent
invent93316363_invent
judgment1944033judgment
kismet123414623kisme_t
lament85024943_lament
legmen939343legmen_
ligaments1246183ligaments
limen75426033li_men_
limens84618033li_mens
liniment1049533liniment
lodgment1245983lodgment
loment84021473_loment
migrant10314313migrant
mismeet113215163mismeet
mismet103722373misme_t
missent94318713missent
moment103319683_moment
nighest11310693nighest
oddment1145923oddment
oilmen848313oilmen_
ointment1069233ointment
orpiment1247973orpi_ment
pageant10312783pageant
parament12415393parament
parent83230423p_arent
patent84524923p_atent
patient9617073patient
pavement1549443pavement
payments1536943payments
pediment13411393pediment
pelmet103419243pelme_t
pendent10314723pendent
penmen10311493penmen_
pent66559073p___ent
percent113520603percent
permeant12310913permeant
perpent112318803perpent
picket144924313picke_t
piedmont1345273piedmont
pigboat1247823pigboat
pigeon949413pig_eon
pigeons1039183pigeons
pigged114214153pigge_d
piggery14266193piggery
piggiest12259663piggiest
piggin103111093piggin_
pigging123614673pigging
piggins113010473piggins
piglets103311793piglets
pigmentary1852953pigmentary
pigmenting1653713pigmenting
pigmies122610993pigmies
pigmy13299433pigm__y
pignut9311573pig_nut
pigout9314613pig_out
pigsney1342873pigsney
pigweed1465093pigweed
pikemen1535333pikemen_
pimentos1246233pi_mentos
pimiento1243253pimiento
pinene82915643pi_nene
piniest93121133piniest
pinken124513283pinken_
pinkens13419643pinkens
pinkest132812623pinkest
pint66963173pi___nt
piolet83225643piole_t
pipet95533323pi_pe_t
pipiest113114493pipiest
piquant1848003piquant
piquet17412353pique_t
pissant91012503pissant
pitman102412123pitman_
pitmans11188743pitmans
poignant1145743poignant
ponent82821593p_onent
portent93619643portent
potent84223353p_otent
potmen102713093potmen_
precent113520263precent
premeet11615153premeet
premen105017803premen_
present94022733present
prevent124016553prevent
primmest14226693primmest
prudent10310433prudent
pschent1437413pschent
pungent10311233pungent
pygmean1542223pygmean
ragmen93712183ragmen_
raiment9315413raiment
regent74127673reg_ent
regiment114414053regiment
repigments1546343repigments
rident7520193ri_dent
ringent8315153ringent
sarment9318763sarment
segments1138903segments
shipment15217593shipment
siemens938413siemens
signet73621153signe_t
silent64125843si_lent
tegmen988403tegmen_
tegmenta1155613tegmenta
tegument1177523tegument
tinmen82310393tinmen_
titmen8239883titmen_
torment9316173torment
unguent839123unguent
urgent73816043urg_ent
varment12313243varment
vimen104114753vi_men_
violent102110813violent
wiglet105519153wigle_t
wingmen1336103wingmen_
wisent93516343wi_sent

Search took 7 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 Filter1786911340270.1731032896.0
2DLD Change Limit1340271786.45320769.7
3Display Results1781780.0632825.4
 (SQL Overall)1786911786.68926714.2
 
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.