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

157 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
figment137974(None) 
figments1446941figments
fitment12710301fitment
pigment12510731pigment
ailment9314232ailment
augment10910202augment
ferment12315572ferment
filament13410032filament
firmest1239272firmest
fitments1376792fitments
foment113718302f_oment
fragment1448372fragment
ligament1149302ligament
pigments1337342pigments
segment10312562segment
affixment2443883affixment
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
exigent1539513exig_ent
ferments13311473ferments
fervent13310063fervent
fidget114216473fidge_t
fiend95312983fi__end
figged124013893figge_d
figging133313563figging
fight124027093fig__ht
figurant1246723figurant
figwort1448223figwort
filaments1446653filaments
filbert12411643filbert
filemot1246703filemot
filet85540163fi_le_t
fillet95027083fille_t
filmed124610363filme_d
filmer114112403filme_r
filmers124211293filmers
filmiest1338553filmiest
filming133210353filming
filmset1257513filmset
finest94321733fi_nest
firemen1238773firemen_
firmament1645403firmament
firman112211343firman_
firmans12238523firmans
firmed125411883firme_d
firmer114712443firme_r
firmers124711443firmers
firming132811223firming
fishnet13410343fishnet
fittest102510803fittest
flagmen13226913flagmen_
flamen115215993flamen_
flamens124611063flamens
fluent9313933f_luent
flymen14387773flymen_
foemen11310523foemen_
foments122912053f_oments
formant123416003formant
fornent10312933fornent
forwent13310533forwent
fragments1546213fragments
frogmen1335893frogmen_
fromenty1645243fromenty
frumenty1644573frumenty
fulgent1138903fulgent
fumet105630223f_ume_t
furmenty1645293furmenty
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
payment14310703payment
piglet93420923pigle_t
pigmented1544063pigmented
pigpen1136583pigpen_
pigpens1235503pigpens
pimento1157223pi_mento
pitmen102510793pitmen_
ragmen93712183ragmen_
raiment9315413raiment
regent74127673reg_ent
regiment114414053regiment
repigment1447923repigment
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 9 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.1561145455.1
2DLD Change Limit1340271578.36016031.9
3Display Results1571570.0463413.0
 (SQL Overall)1786911578.56220870.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.