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 “offsetting” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

185 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
offsetting174233(None) 
affecting1845233aff_ecting
bassetting1344633bassetting
befretting1644793befretting
besetting12268423_besetting
effecting1845583eff_ecting
facetting1535283_facetting
fetting113517873__f_etting
forgetting1544663forgetting
fretting122711523__fretting
insetting1079283_insetting
missetting13107903missetting
offending1744093off_ending
offering1536393off_e_ring
offspring1842123offs_pring
outsitting1147133outsitting
oversetting1548813oversetting
poussetting1452813poussetting
presetting131010833presetting
resetting102816293_resetting
russetting1184253russetting
setting83621393___setting
unsetting1088993_unsetting
upsetting1275563_upsetting
wadsetting1542913wadsetting
abetting1158294__abetting
absenting1236994_absenting
afflicting1943484afflicting
afforesting1852854afforesting
affronting1742604affronting
assenting1038164_assenting
asserting1038664_asserting
basseting1236154basse_ting
befitting15236624bef_itting
begetting13186584_begetting
besotting12256874_besotting
betting103921404___betting
bisecting1436974_bisecting
brevetting1644334brevetting
buffeting1843784buffe_ting
caseating12311744_caseating
closeting1236184close_ting
coffering1838044coff_e_ring
confecting18310554conf_ecting
consenting13313214consenting
coquetting2244514coquetting
corseting12312174corse_ting
cosseting1239544cosse_ting
curetting1236574_curetting
curvetting1643394curvetting
defatting1436104def_atting
defeating142311974def_eating
defecting162510224def_ecting
deflecting1736504deflecting
deserting11713144_deserting
dipnetting1453624dipnetting
disseating121111784disseating
dissecting14139474dissecting
dissenting121310294dissenting
disserting121310854disserting
duetting1047184__duetting
exsecting1935934_exsecting
exserting1736664_exserting
eyeletting1442874eyeletting
faceting1438784_face_ting
fastening13268604_fastening
fasting114522834_fas__ting
fatting113818704__f_atting
felting113515214__f_elting
festering132413174_festering
feting104417794__f_e_ting
fettling1266774__f_ettling
fileting1239304_file_ting
filmsetting1751874filmsetting
fisting113818124_fis__ting
fitting113516564__f_itting
flatting123511254__flatting
fleeting122910324__fleeting
flitting123010884__flitting
foisting122910504fois__ting
fomenting1537234_fomenting
foresting13311364_foresting
forfeiting1744134forfeiting
formatting1644164formatting
fostering132411264_fostering
fritting123510704__fritting
gazetting2043244_gazetting
getting93316564___getting
gibbetting1642314gibbetting
goffering1744484goff_e_ring
gusseting1173964gusse_ting
infecting15109674inf_ecting
infesting13109514inf_esting
inflecting1646314inflecting
inletting1087874_inletting
inserting10914234_inserting
jetting153815344___jetting
leafletting1541984leafletting
letting83218534___letting
miseating121215434_miseating
misfitting1645534misfitting
misseating131310944misseating
nauseating1144984nauseating
netting84018764___netting
nonbetting1345844nonbetting
obfuscating1951674obfuscating
objecting2144054o_bjecting
observing1544384o_bserving
obsessing1244264o_bsessing
obtesting1245884o_btesting
obverting1536304o_bverting
offerings1643654off_e_rings
officering1942144officering
officiating2052924officiating
offing13368644off____ing
offloading1842164offloading
offprinting2052114offprinting
offscouring2051104offscouring
offset1238374offse_t___
offsets1333504offse_t__s
offsprings1951314offs_prings
omitting11217744o__mitting
orienting1038724o_rienting
ousting84021354o_us__ting
outeating10814494o_uteating
outfitting1465824outfitting
outhitting1446334outhitting
outjutting1844264outjutting
outputting1345084outputting
outseeing1038334outse_eing
outselling1188024outselling
outserving1446744outserving
outskating1536854outskating
outstating1139364outstating
outwitting1445554outwitting
overbetting1747454overbetting
overeating141016534overeating
overletting1548014overletting
overwetting1847254overwetting
oystering1337564o_ystering
pacesetting1652634pacesetting
pargetting1444944pargetting
petting103720954___petting
photosetting1854254photosetting
pipetting1435514_pipetting
presenting131013024presenting
presettling1444454presettling
prosecting15189814prosecting
refecting152413354ref_ecting
refitting132811124ref_itting
reflecting1638824reflecting
regretting1237784regretting
reletting102713944_reletting
reseating102421534_reseating
resecting122816484_resecting
resenting102619294_resenting
resettling1135894_resettling
resitting103414874_resitting
retting83425884___retting
revetting132912634_revetting
rewetting132710444_rewetting
rivetting13256414_rivetting
rouletting1144754rouletting
russeting1065324russe_ting
russettings12101574russettings
safetying1643074saf_etying
seating84130684___seating
settings93810074___settings
settling978944___settling
sitting83519634___sitting
somersetting1552184somersetting
sonnetting1144824sonnetting
stetting93410714__stetting
subletting1346274subletting
tabletting1344084tabletting
telnetting1143884telnetting
trisecting1345504trisecting
typesetting1752224typesetting
unfitting1336424unf_itting
unseating10713204_unseating
unsettling1144434_unsettling
vetting114216564___vetting
vignetting1542824vignetting
wetting114117384___wetting
whetting1535974__whetting

Search took 10 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 Filter1786911614500.1731032896.0
2DLD Change Limit1614501859.40617164.6
3Display Results1851850.0762434.2
 (SQL Overall)1786911859.65518507.6
 
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.