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

327 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
ferment1231557(None) 
ferments13311471ferments
fervent13310061fervent
averment13311602averment
cement103321672ce_ment
cerement12315132cerement
cermet10321152cerme_t
deferment151210302deferment
dement93825152de_ment
fermented1546622fermented
fermenter1497542fermenter
fermentor1444692fermentor
ferret93021172ferre_t
figment1379742figment
firmest1239272firmest
fitment12710302fitment
foment113718302f_oment
formant123416002formant
fornent10312932fornent
forwent13310532forwent
furmenty1645292furmenty
garment10315232garment
gerent73223102ger_ent
germen9612312germen_
germens1078632germens
mermen10813812mermen_
percent113520602percent
permeant12310912permeant
perpent112318812perpent
rerent63832452rer_ent
sarment9318762sarment
segment10312562segment
serpent92916282serpent
torment9316172torment
varment12313242varment
abetment1248233abetment
aeriest73924053aeriest
afferent1447983affer_ent
ailment9314233ailment
airmen82612353airmen_
aliment9316703aliment
ament76036543__ament
aperient10715153aperient
ardent73022613_ardent
argent74023663_argent
armet76739453_arme_t
arpent84822093_arpent
augment10910203augment
averments1449093averments
barmen105418533barmen_
bereft114317303ber_eft
beret74946363ber_e_t
berme96022943berme__
bermed115217723berme_d
bermes106023003berme_s
berming123614833berming
brent75734133_br_ent
carmen104019343carmen_
cementa112810543ce_menta
cements112714223ce_ments
cerements13411453cerements
cermets1139713cermets
cerumen1147763cerumen_
cerumens1235763cerumens
clement11313773clement
comment1310317703comment
conferment17410373conferment
credent10313973credent
current9313693current
debarment1447793debarment
decent94023703de_cent
decrement14411053decrement
deferent122712873defer_ent
deferments16128583deferments
dements103016623de_ments
descent102616293descent
detent73624483de_tent
determent121312903determent
detriment1249693detriment
diriment11410743diriment
dormant102814373dormant
dormient1148453dormient
eeriest73620673eeriest
efferent1447203effer_ent
element9317803element
eluent6315483_eluent
emend86214893_e_mend
emergent1149113emergent
emmet94221383_emme_t
erect74129333_er_ect
ermine8416923_ermine
erodent8313823_erodent
errant6618733_errant
erumpent1245453_erumpent
event85924443_e_vent
extent132714913_extent
farmed125117653farme_d
farmer115017373farme_r
farmers124315263farmers
farming133515083farming
featest102715113featest
feculent1346953feculent
feet75352213fe__e_t
feint84732253fe__int
fellest10313753fellest
feme96130543fe_me__
femes105626223fe_me_s
femme125011433femme__
femmes135410213femme_s
feoffment1652603feoffment
fere76342233fer_e__
feres86038183fer_e_s
ferine96422583fer_ine
fermata12278143fermata
fermate122813003fermate
fermenters15116533fermenters
fermenting1646823fermenting
fermentors1594233fermentors
fermi103914163ferm__i
fermion1236763fermion
fermions1336203fermions
fermis114313503ferm_is
fermium1446353fermium
fern76129323fer__n_
fernery1335813fernery
ferniest1132214153ferniest
ferninst11238323ferninst
ferns85220083fer__ns
ferny115816183fer__ny
ferrel92810203ferre_l
ferrels10248623ferrels
ferrets103111393ferrets
ferrety13287013ferrety
ferrymen1643943ferrymen_
fervency1944383fervency
fervently1845143fervently
fewest12311663fe_west
feyest12311403fe_yest
fiercest13216143fiercest
fieriest112112243fieriest
figments1446943figments
filament13410033filament
firemen1238773firemen_
firmament1645403firmament
firman112211343firman_
firmans12238523firmans
firmed125411883firme_d
firmer114712443firme_r
firmers124711443firmers
firming132811223firming
fitments1376793fitments
flamen115215993flamen_
flamens124611063flamens
flehmen1534913flehmen_
flehmens1643233flehmens
fleshment1745503fleshment
fluent9313933f_luent
flymen14387773flymen_
foemen11310523foemen_
foments122912053f_oments
foramen12310533foramen_
foramens1337823foramens
foremen12412923foremen_
forest94926743for_est
forewent1439423forewent
forfeit1339203forfeit
forfend1435413forfend
forget106326393forge_t
forint9325023for_int
formants13269953formants
format113021353form_at
forme105225993forme__
formed125021173forme_d
formee113919943forme_e
former114221403forme_r
formers128217953formers
formes114623713forme_s
forming133615733forming
forspent1348163forspent
fraena938063f_raena
fragment1448373fragment
freemen1238463freemen_
freest95318283f_reest
frena85915273f_r_ena
frequent2046423frequent
fret75845043f_r_e_t
friend10388933f_riend
fromenty1645243fromenty
front85029223f_r_ont
frumenty1644573frumenty
fulgent1138903fulgent
fumet105630223f_ume_t
furmety1534813furmety
garments1139963garments
gerents82612923ger_ents
german9611983german_
germane1049663germane
germans1079473germans
germiest11249923germiest
germina1038503germina
helmet113718933helme_t
herdmen13238453herdmen_
hereat93527413her_eat
hermit11519443herm_it
horrent10313553horrent
hutment1239173hutment
interment11419223interment
kermes124616133kerme_s
kermess13396223kermess
lament85024943_lament
legmen939343legmen_
lenient7313843lenient
loment84021473_loment
margent10316693margent
memento11378133me_mento
merest84725113mer_est
merman10513863merman_
merriment1358033merriment
moment103319683_moment
mordent10313993mordent
oddment1145923oddment
orient6322533_orient
overlent112715293overlent
overmelt13310713overmelt
overmen12311803overmen_
parament12415393parament
parent83230423par_ent
payment14310703payment
pediment13411393pediment
pelmet103419243pelme_t
pendent10314723pendent
penmen10311493penmen_
percents122713373percents
percept133112523percept
perfect141010833perfect
permanent1368783permanent
permeate12311613permeate
permed115217353perme_d
perming123416093perming
permit10321683perm_it
perpend12259353perpend
perpents122312043perpents
pertest9317043pertest
pervert12315583pervert
pigment12510733pigment
portent93619643portent
precent113520263precent
preferment1746323preferment
premeet11615153premeet
premen105017803premen_
present94022733present
prevent124016553prevent
raiment9315413raiment
reagent8716603reagent
reblent9614253reblent
recement12315653recement
recent83630853re_cent
recrement13411363recrement
referent112813423refer_ent
regent74127673re_gent
regiment114414053regiment
relent64431853re_lent
remeet86325473re_meet
remelt85123123re_melt
remend95216553re_mend
remet74843723re_me_t
remint85329983re_mint
rent46661243__r_ent
reorient8613473reorient
repent84728873re_pent
rerents73319423rer_ents
resent63833623re_sent
resmelt9411773resmelt
sarmenta1047723sarmenta
sarments10311963sarments
seamen84518563seamen_
sediment11411103sediment
segments1138903segments
semen75724103se_men_
semens84616973se_mens
sequent16410323sequent
serene63522353ser_ene
serest64831613ser_est
sergeant9129403sergeant
serjeant1596473serjeant
sermon8413553sermon_
sermons9311783sermons
serpents102410373serpents
servant10313633servant
sorbent92915243sorbent
sprent84522383spr_ent
tegmen988403tegmen_
tegmenta1155613tegmenta
tegument1177523tegument
tenement10412593tenement
tercet83624913terce_t
termed94816703terme_d
termer85717253terme_r
termers95414503termers
terming104016003terming
termini93410813termini
terpene92310863terpene
terrene72411033terrene
terret63425623terre_t
tersest71713993tersest
torments10310453torments
torrent7313413torrent
turgent8712393turgent
unrent63219783unr_ent
urgent73816043_urgent
varments1339063varments
varmint12311683varmint
vehement1647763vehement
verbena1235373verbena
verdant11313293verdant
veriest103719133veriest
vermeil1285223vermeil
vermes115019143verme_s
vermin113414523vermin_
versant10313833versant
verset94327323verse_t
vervet124619063verve_t
vestment13109203vestment
warmest123113033warmest
weldment1445823weldment
wergelt1138583wergelt
yeomen1138183yeomen_

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.436409841.7
2DLD Change Limit1340273276.64020184.8
3Display Results3273270.1102972.7
 (SQL Overall)1786913277.18624866.5
 
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.