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

219 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
offered143614(None) 
coffered1737671coffered
goffered1634521goffered
offerer1335541offerer
buffered1764992buffered
differed1635522differed
niffered1544142niffered
ochered132610282ochered
offed12359162off__ed
offend13365662offe_nd
offended1643652offended
offer114311382offer__
offerers1434932offerers
offeror1342942offeror
offers12349962offer_s
officered1841912officered
ordered9108532ordered
osiered837122osiered
overed102216622o_vered
proffered1843432proffered
reoffered1643312reoffered
suffered1536732suffered
unoffered1643362unoffered
wafered14288432wafered
adhered1239233adhered
afeared1176833afeared
affected1744793affected
afferent1447983afferent
affined1436413affined
affirmed1743213affirmed
affixed2134123affixed
afford1346493affor_d
afforded1643433afforded
altered83215733altered
angered93013473angered
boffed15369483boff__ed
bordered1248933bordered
bothered142110393bothered
bowered133113043bowered
buffeted1753733buffeted
capered123014043capered
catered103117763catered
cered85227443__cered
chaffered21154473chaffered
cheered133713293cheered
cockered17710213cockered
coffee144113743coffe_e_
coffees15329573coffe_es
coffer144112863coffer__
coffers154112693coffer_s
coffined1735993coffined
coffled16297363coff_led
coffret15310073coff_ret
cohered133514693cohered
coiffured1842603coiffured
compered153414923compered
conferee13613723conferee
conferred1537753conferred
coopered133310933coopered
coppered153410543coppered
cornered11311133cornered
coshered14610293coshered
cottered112511733cottered
covered133315293covered
cowered133214643cowered
deferred13106363deferred
doddered1234943doddered
doffed14428503doff__ed
doffer133911353doffer__
doffers14359853doffer_s
donnered10307753donnered
dormered1255673dormered
dowered122811553dowered
effaced16225573effaced
effected1744993effected
efferent1447203efferent
effete1235183effete_
effused1434143effused
entered82718883entered
faired105915773_faired
fared95842343__fared
feared106320433_feared
feed84538903__fe_ed
feezed19439993_feezed
fere76342233__fere_
feres86038183__feres
feted94420933__feted
feued94715663__feued
fevered14339723fevered
fibered1337643fibered
fired94829743__fired
flared105317603_flared
fleered11309503fleered
flexed17419083_flexed
fleyed13408813_fleyed
foddered1434553foddered
fostered122210443fostered
freed95223543_fre_ed
frere85617723_frere_
freres94716173_freres
fueled104913603_fueled
furred104514433_furred
gauffered1741873gauffered
goffer13409513goffer__
goffers14409213goffer_s
havered144011453havered
hollered1237603hollered
homered133212713homered
hoovered15195413hoovered
hovered143411573hovered
inferred12248353inferred
inhered11313163inhered
jeered143912793_jeered
koshered1636063koshered
lagered92311153lagered
layered11259413layered
leered73816223_leered
levered114212303levered
livered113111633livered
loitered938183loitered
loppered13326753loppered
louvered1244993louvered
lowered112711913lowered
metered103514013metered
mitered103213233mitered
moldered1237173moldered
mongered1238953mongered
mothered142310103mothered
mufflered1842123mufflered
oared65030653o__ared
obeyed1235823o_beyed
observed1444373observed
obverted1435103obverted
ochred12328003o_chred
odored8399223o_dored
offence1545353offence
offences1645023offences
offender1543723offender
offends14234293offends
offense1343683offense
offenses1443833offenses
offering1536393offering
offerors1443533offerors
offhand1742883offhand
office1435693office_
officer1534213officer
offices1536243offices
offkey1932343off_key
offload1443203offload
offset1238373off_set
offside1453693offside
oftener1035923oftener
ofter84116873ofter__
omened93711003o_mened
opened94311863o_pened
orderer8127943orderer
outbred10311263outbred
outfired1238083outfired
overbed132811843o_verbed
overfed142510253o_verfed
oxford1763663oxfor_d
oystered1236913oystered
papered122513163papered
peered93819483_peered
petered103314963petered
pilfered1435853pilfered
pondered126411293pondered
portered112311533portered
pothered142311043pothered
pottered112311663pottered
powdered15256893powdered
powered132911643powered
profferer1742933profferer
queered17117213queered
raftered1237663raftered
refeed104717623refe_ed
referee101615753referee
refereed12149693refereed
referred1297833referred
refired115116993refired
revered112819333revered
rogered939553rogered
sabered103213023sabered
sered65737293__sered
severed113513863severed
sewered112911243sewered
sheered113515453sheered
sneered83113973sneered
sobered102912433sobered
softened1235663softened
soldered1038153soldered
speered103614813speered
sphered133512313sphered
spiered104412463spiered
steered83615253steered
sufferer1436063sufferer
supered10316123supered
tabered103311593tabered
tafferel1443123tafferel
tapered102612933tapered
telfered1234883telfered
tiered73613973_tiered
tochered1437913tochered
toffee123311013toffe_e_
toffees13327083toffe_es
tottered9208703tottered
towered112911403towered
ulcered1037973ulcered
umbered121510113umbered
unfeared121511013unfeared
unfired112212453unfired
unfreed11510123unfreed
ushered1139153ushered
uttered82712433uttered
veered103612743_veered
wagered12299333wagered
watered113014953watered
wavered142910433wavered
wondered13239943wondered

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.1431249587.4
2DLD Change Limit1340272197.48317910.9
3Display Results2192190.1101990.9
 (SQL Overall)1786912197.73623098.6
 
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.