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

217 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
fervent1331006(None) 
ferment12315571ferment
event85924442_e_vent
ferments13311472ferments
ferret93021172ferre_t
fervency1944382fervency
fervently1845142fervently
fornent10312932fornent
forwent13310532forwent
gerent73223102ger_ent
percent113520602percent
perpent112318812perpent
pervert12315582pervert
prevent124016552prevent
rerent63832452rer_ent
serpent92916282serpent
servant10313632servant
vervet124619062verve_t
advent102613753_advent
aeriest73924053aeriest
afferent1447983affer_ent
aperient10715153aperient
ardent73022613_ardent
argent74023663_argent
arpent84822093_arpent
averment13311603averment
bereft114317303ber_eft
beret74946363ber_e_t
brent75734133_br_ent
brevet115717343breve_t
carven114716663carven_
cement103321673ce_ment
cerement12315133cerement
cermet10321153cerme_t
cervelat1345793cervelat
cerveza2142333cerveza
cervine122610803cervine
convent123919413convent
corvet114626933corve_t
credent10313973credent
current9313693current
curvet114720243curve_t
decent94023703de_cent
deferent122712873defer_ent
deferment151210303deferment
dement93825153de_ment
descent102616293descent
detent73624483de_tent
devest104418703de_vest
eeriest73620673eeriest
efferent1447203effer_ent
eluent6315483_eluent
emergent1149113emergent
erect74129333_er_ect
erodent8313823_erodent
errant6618733_errant
even75222273_e_ven_
evens84817103_e_vens
events94814073_e_vents
evert84929513_e_vert
extent132714913_extent
featest102715113featest
feculent1346953feculent
feet75352213fe__e_t
feint84732253fe__int
fellest10313753fellest
fere76342233fer_e__
feres86038183fer_e_s
ferine96422583fer_ine
fermented1546623fermented
fermenter1497543fermenter
fermentor1444693fermentor
fern76129323fer__n_
fernery1335813fernery
ferniest1132214153ferniest
ferninst11238323ferninst
ferns85220083fer__ns
ferny115816183fer__ny
ferrel92810203ferre_l
ferrels10248623ferrels
ferrets103111393ferrets
ferrety13287013ferrety
fervid1337513ferv_id
fervor1235643ferv_or
fervors1336233fervors
fervour1343103fervour
fever115617953fe_ve_r
fevers125414893fe_vers
fewest12311663fe_west
feyest12311403fe_yest
fiercest13216143fiercest
fieriest112112243fieriest
figment1379743figment
firmest1239273firmest
fitment12710303fitment
fluent9313933f_luent
foment113718303f_oment
forest94926743for_est
forewent1439423forewent
forfeit1339203forfeit
forfend1435413forfend
forget106326393forge_t
forint9325023for_int
formant123416003formant
forspent1348163forspent
fraena938063f_raena
freest95318283f_reest
frena85915273f_r_ena
frequent2046423frequent
fret75845043f_r_e_t
friend10388933f_riend
front85029223f_r_ont
fulgent1138903fulgent
furmenty1645293furmenty
garment10315233garment
gerents82612923ger_ents
germen9612313germen_
germens1078633germens
harvest132112753harvest
heaven123912603heaven_
heavens13439303heavens
hereat93527413her_eat
horrent10313553horrent
invent93316363_invent
leaven95013073leaven_
leavens10409303leavens
lenient7313843lenient
levant9314493le_vant
margent10316693margent
merest84725113mer_est
mermen10813813mermen_
mordent10313993mordent
nerve86617373nerve__
nerved104111693nerve_d
nerves94216193nerve_s
nerviest11188833nerviest
nervine102510633nervine
nerving112910833nerving
orient6322533_orient
overlent112715293overlent
parent83230423par_ent
parvenu1247023parvenu
pendent10314723pendent
percents122713373percents
percept133112523percept
perfect141010833perfect
permeant12310913permeant
perpend12259353perpend
perpents122312043perpents
pertest9317043pertest
perverts1337533perverts
portent93619643portent
precent113520263precent
present94022733present
prevents133012303prevents
reagent8716603reagent
reblent9614253reblent
recent83630853re_cent
referent112813423refer_ent
regent74127673re_gent
reinvent1138903reinvent
relent64431853re_lent
rent46661243__r_ent
reorient8613473reorient
repent84728873re_pent
rerents73319423rer_ents
resent63833623re_sent
revert93529113re_vert
revest94623603re_vest
revet84938843re_ve_t
sarment9318763sarment
segment10312563segment
sequent16410323sequent
serene63522353ser_ene
serest64831613ser_est
sergeant9129403sergeant
serjeant1596473serjeant
serpents102410373serpents
servants1138003servants
serve85425963serve__
served104616813serve_d
server94917713serve_r
servers103214833servers
serves94423653serve_s
serving113014983serving
seven84118313se_ven_
sevens93813663se_vens
seventh1336773se_venth
seventy1338033se_venty
sirvente1145023sirvente
solvent10310833solvent
sorbent92915243sorbent
sprent84522383spr_ent
tercet83624913terce_t
terpene92310863terpene
terrene72411033terrene
terret63425623terre_t
tersest71713993tersest
tervalent1245573tervalent
torment9316173torment
torrent7313413torrent
trevet94818913treve_t
turgent8712393turgent
unrent63219783unr_ent
urgent73816043_urgent
varment12313243varment
velvet123613753velve_t
vent76049053___vent
verbena1235373verbena
verdant11313293verdant
veriest103719133veriest
versant10313833versant
verset94327323verse_t
verve115417723verve__
verves124617883verve_s
vervets13419753vervets
wergelt1138583wergelt

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.436409841.7
2DLD Change Limit1340272178.06316622.5
3Display Results2172170.0802712.5
 (SQL Overall)1786912178.57920828.9
 
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.