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

179 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
offering153639(None) 
coffering1838041coffering
goffering1744481goffering
offerings1643651offerings
buffering1835222buffering
differing1746482differing
gofferings1842222gofferings
niffering1645132niffering
ochering14219392ochering
offending1744092offending
officering1942142officering
offing13368642off__ing
offprint1643962offprint
offspring1842122offspring
ordering1039352ordering
overing111918052o_vering
proffering1943772proffering
reoffering1744092reoffering
suffering1637292suffering
wafering15208892wafering
adhering1338883adhering
affecting1845233affecting
afferent1447983afferent
affirming1843103affirming
affixing2264333affixing
affording1744023affording
altering91917123altering
angering102113803angering
boffing16339983boff__ing
bordering1338833bordering
bothering152210203bothering
bowering142911713bowering
buffeting1843783buffeting
capering132414963capering
catering112019913catering
cering94522533__cering
chaffering22104643chaffering
cheering143612703cheering
cockering1839693cockering
coffing163811253coff__ing
coffining1845483coffining
coffling1736483coff_ling
cohering142413843cohering
coiffuring1942573coiffuring
compering163414163compering
conferring1648743conferring
coopering142611323coopering
coppering162810893coppering
cornering12311893cornering
coshering15510023coshering
covering142215733covering
cowering142514043cowering
deferring1436143deferring
doddering1335183doddering
doffing15357793doff__ing
dowering132510613dowering
effacing1744463effacing
effecting1845583effecting
efferent1447203efferent
effusing1534273effusing
entering91920053entering
fairing113614013_fairing
faring105231283__faring
fearing113520033_fearing
feeding123515073_feeding
feeing104416503__feeing
feeling113617073_feeling
feezing204610163_feezing
ferine96422583__ferine
feting104417793__feting
feuing104412273__feuing
fevering152510083fevering
firing104021723__firing
flaring114116803_flaring
fleeing113511293_fleeing
fleering123811283fleering
flexing18358993_flexing
fleying14329873_fleying
foddering1535163foddering
forewing1539003forewing
fostering132411263fostering
freeing113713913_freeing
fueling113615133_fueling
furring114013143_furring
gauffering1842453gauffering
havering152211053havering
hollering1337743hollering
homering141512073homering
hoovering1635753hoovering
hovering151911143hovering
inferring1338613inferring
inhering12913713inhering
jeering153513043_jeering
koshering1735363koshering
lagering102212313lagering
layering122310353layering
leering83417643_leering
levering122212503levering
livering122012383livering
loitering1039683loitering
loppering14237283loppering
lowering122210913lowering
metering112915633metering
mitering113015403mitering
moldering1367863moldering
mongering13310353mongering
mothering152110183mothering
nidering10510483nidering
oaring74225303o__aring
obeying1336543o_beying
observing1544393observing
obverting1536303obverting
ochring13156673o_chring
offend13365663offe__nd
offer114311383offer___
offered1436143offer_ed
offerer1335543offer_er
offerers1434933offerers
offeror1342943offer_or
offerors1443533offerors
offers12349963offer__s
offings14285833off__ings
offline1345783off_line
offprints1742443offprints
offsetting1742333offsetting
offsprings1951313offsprings
omening10310103o_mening
opening1039933o_pening
outfiring1338163outfiring
outring84021023o_utring
oystering1337563oystering
papering132213313papering
peering103520353_peering
petering112516813petering
pilfering1536393pilfering
pondering132411333pondering
portering122012303portering
pothering151911283pothering
pottering122612003pottering
powdering16246503powdering
powering142210803powering
queering1838203queering
referring1338033referring
refiring123513923refiring
revering122918073revering
rogering10310273rogering
sabering112113743sabering
sering74731813__sering
severing122013853severing
sewering122411093sewering
sheering123715103sheering
sneering93414503sneering
sobering111912783sobering
softening1365493softening
soldering1169033soldering
solferino1243873solferino
speering113116323speering
sphering142811943sphering
spiering112713353spiering
steering93916793steering
sufferings1743233sufferings
supering11317683supering
tabering112211423tabering
tapering112112503tapering
telfering1336253telfering
tiering8315253_tiering
tochering1537153tochering
tottering10229613tottering
towering122610873towering
ulcering1139333ulcering
umbering1399433umbering
unfearing1338883unfearing
ushering1258923ushering
uttering91613083uttering
veering113213683_veering
wagering13219523wagering
watering122316323watering
wavering152410543wavering
wondering142110463wondering

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621798.20317818.1
3Display Results1791790.0762355.3
 (SQL Overall)1786911798.68520574.7
 
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.