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

123 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
goffered163452(None) 
coffered1737671coffered
offered1436141_offered
buffered1764992buffered
differed1635522differed
gauffered1741872gauffered
goffer13409512goffer__
goffers14409212goffer_s
niffered1544142niffered
offerer1335542_offerer
proffered1843432proffered
reoffered1643312reoffered
suffered1536732suffered
unoffered1643362unoffered
boffed15369483boff__ed
bordered1248933bordered
bothered142110393bothered
bowered133113043bo_wered
buffeted1753733buffeted
chaffered21154483chaffered
cockered17710213cockered
coffee144113743coffe_e_
coffees15329573coffe_es
coffer144112863coffer__
coffers154112693coffer_s
coffined1735993coffined
coffled16297363coff_led
coffret15310073coff_ret
cohered133514693co_hered
coiffured1842613coiffured
compered153414923compered
conferee13613733conferee
conferred1537753conferred
coopered133310933coopered
coppered153410543coppered
cornered11311133cornered
coshered14610293coshered
cottered112511733cottered
covered133315293co_vered
cowered133214653co_wered
doddered1234943doddered
doffed14428503doff__ed
doffer133911353doffer__
doffers14359853doffer_s
donnered10307753donnered
dormered1255673dormered
dowered122811553do_wered
foddered1434553foddered
fostered122210453fostered
gaffed144210203gaff__ed
gaffer134310133gaffer__
gaffers14428713gaffer_s
gandered112211173gandered
garnered10247113garnered
gartered10319583gartered
gathered13149373gathered
gendered11258873gendered
gettered10258613gettered
gibbered1444303gibbered
gingered11127743gingered
glowered1345753glowered
goateed9307063goate_ed
gofer94814283go_fer__
gofers104711513go_fer_s
goffering1744483goffering
golfed11569763golf__ed
golfer104411183golfer__
golfers114410083golfer_s
gomerel1036393go_merel
goofed114911383goof__ed
gored75227083go___red
gorgeted1135353gorgeted
governed1335193go_verned
guffawed1941623guffawed
guttered10259163guttered
hollered1237603hollered
homered133212713ho_mered
hoovered15195413hoovered
hovered143411573ho_vered
koshered1636063koshered
loitered938183loitered
loppered13326753loppered
louvered1244993louvered
lowered112711913lo_wered
moldered1237173moldered
mongered1238953mongered
mothered142310103mothered
mufflered1842123mufflered
ochered132610283_ochered
offed12359163_off__ed
offend13365663_offe_nd
offended1643653_offended
offer114311383_offer__
offerers1434933_offerers
offeror1342943_offeror
offers12349963_offer_s
officered1841913_officered
ordered9108533_ordered
osiered837123_osiered
overed102216623_o_vered
pilfered1435853pilfered
pondered126411293pondered
portered112311543portered
pothered142311043pothered
pottered112311663pottered
powdered15256893powdered
powered132911643po_wered
profferer1742933profferer
raftered1237663raftered
rogered939553ro_gered
sobered102912433so_bered
softened1235663softened
soldered1038153soldered
sufferer1436063sufferer
tafferel1443123tafferel
telfered1234883telfered
tochered1437913tochered
toffee123311013toffe_e_
toffees13327083toffe_es
tottered9208703tottered
towered112911403to_wered
wafered14288433_wafered
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 Filter1786911461620.423422437.4
2DLD Change Limit1461621237.06020702.8
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.52923733.7
 
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.