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

161 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
fitment1271030(None) 
figment1379741figment
fitments1376791fitments
ailment9314232ailment
ferment12315572ferment
figments1446942figments
filament13410032filament
firmest1239272firmest
fittest102510802fittest
foment113718302f_oment
hitmen11239192hitmen_
hutment1239172hutment
ointment1069232ointment
pigment12510732pigment
pitmen102510792pitmen_
titmen8239882titmen_
abetment1248233abetment
abutment1247223abutment
affixment2443883affixment
aidmen92610373aidmen_
ailments1039443ailments
airmen82612353airmen_
aliment9316703aliment
ament76036543__ament
attent62818323_attent
augment10910203augment
bailment1249183bailment
batmen104414303batmen_
bitten84715123bitten_
bitumen1134503bitumen_
bitumens1243523bitumens
catmint11314463catmint
cement103321673_cement
clement11313773clement
comment1310317703comment
dement93825153_dement
detent73624483det_ent
diluent8310263diluent
dimmest1249253dimmest
diriment11410743diriment
dissent84018683dissent
distent84120853distent
element9317803element
extent132714913ext_ent
fatten94314903fatten_
fattens105111713fattens
fattest102913063fattest
ferments13311473ferments
fervent13310063fervent
fidget114216483fidge_t
fiend95312983fi__end
fifteen1343923fifteen_
fifteens1442753fifteens
fifteenth1851813fifteenth
filaments1446653filaments
filbert12411643filbert
filemot1246703filemot
filet85540163fi_le_t
fillet95027083fille_t
filmed124610363filme_d
filmer114112403filme_r
filmers124211293filmers
filmiest1338553filmiest
filming133210353filming
filmset1257513filmset
finest94321733fi_nest
firemen1238773firemen_
firmament1645403firmament
firman112211353firman_
firmans12238523firmans
firmed125411883firme_d
firmer114712443firme_r
firmers124711443firmers
firming132811223firming
fishnet13410343fishnet
fitchet153113563fitchet
fitness10299393fitness
fitted104716663fitte_d
fitter94120033fitte_r
fitters104517753fitters
fitting113516563fitting
flamen115215993flamen_
flamens124611063flamens
fluent9313933f_luent
flymen14387773flymen_
foemen11310523foemen_
foments122912053f_oments
footmen1246583footmen_
formant123416003formant
fornent10312933fornent
forwent13310533forwent
fragment1448373fragment
fromenty1645243fromenty
frumenty1644573frumenty
fulgent1138903fulgent
fumet105630223f_ume_t
furmenty1645293furmenty
garment10315233garment
hitman112710223hitman_
hutments1345603hutments
incent83320723_incent
indent73021243_indent
intent63122773_intent
invent93316363_invent
kismet123414623kisme_t
kitten104611483kitten_
kittens11347583kittens
lament85024943_lament
latent64124303lat_ent
liftmen1234233liftmen_
ligament1149313ligament
limen75426033li_men_
limens84618033li_mens
liniment1049533liniment
lithest10513913lithest
litten64014873litten_
loment84021473_loment
mismeet113215163mismeet
mismet103722373misme_t
missent94318713missent
mitiest93520053mitiest
mitten83914093mitten_
mittens9349883mittens
moment103319683_moment
nutmeat947953nutmeat
oddment1145923oddment
oilmen848313oilmen_
ointments1166653ointments
outwent10311363outwent
patent84524923pat_ent
patient9617073patient
payment14310703payment
pigments1337343pigments
pimento1157223pi_mento
pitman102412123pitman_
pitmans11188743pitmans
potent84223353pot_ent
potmen102713093potmen_
quitrent1746963quitrent
raiment9315413raiment
remitment1349443remitment
rident7520193ri_dent
ringent8315153ringent
sarment9318763sarment
segment10312563segment
shipment15217593shipment
siemens938413siemens
silent64125843si_lent
sithens1039383sithens
sitten64113823sitten_
stent55634513_st_ent
tent46159863__t_ent
tinmen82310403tinmen_
titman82711003titman_
titrant7315193titrant
torment9316173torment
varment12313243varment
vestment13109203vestment
vimen104114753vi_men_
violent102110813violent
wisent93516343wi_sent

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271616.76319817.7
3Display Results1611610.0463500.0
 (SQL Overall)1786911617.23224708.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.